SPIP backup as a cron job?

Hello,

all the talk today about database migration made me think to a related
issue.

Assume you have set up your site. It is very active, lots of
contributors, etc...

How do you back it up every night from the command line? I mean, say
you have a server running some distro Linux.

What and how do you save with a shell script in *one* tarball
my_spip_site_YYYMMDD.tar.gz, so that if the server crashes/burns/is
stolen, whatever, you buy a new PC, install the same packages, and
then from that one tarball (with as little *manual* intervention as
possible) the site goes online again?

TIA,
Marco

Marco wrote:

How do you back it up every night from the command line?

Marco,

There was a discussion about this recently on the French Spip-user list
(startng on 25 May).

There is a script here:
http://spip.japanim.net/sauvegarde.php
- but it is no longer maintained by the author. However, at least one person
says they use it without problems on Spip 1.7

Nicolas Hoizey offers his script:
http://www.gasteroprod.com/data/spipDump2.zip

but it is not yet "automated". And although I could get it to back up my
database, I could not restore the files it produced (it corrupted the whole
site and I had to reinstall from a Spip backup). I *think* the problem is
that it is not UTF-8 compatible - but I'm not sure.

If you make any progress on the subject, let us know!

Paolo

On Fri, Jun 04, 2004 20:19:44 PM +0200, Paolo (paolo2@taize.fr) wrote:

Marco wrote:
> How do you back it up every night from the command line?

Marco,

There was a discussion about this recently on the French Spip-user list
(startng on 25 May).

There is a script here:
http://spip.japanim.net/sauvegarde.php
- but it is no longer maintained by the author. However, at least one person
says they use it without problems on Spip 1.7

Nicolas Hoizey offers his script:
http://www.gasteroprod.com/data/spipDump2.zip

Thanks, I'll try those

Marco