|There's more than one way to do things
Perl MySQL backup - what's the best way?by cosmicperl (Chaplain)
|on Dec 13, 2007 at 15:49 UTC
cosmicperl has asked for the wisdom of the Perl Monks concerning the following question:
I've got a script that's running on a few different shared hosting accounts. They use a mysql database and I'm trying to figure out what the best way to write a back and restore routine would be.
As these are on shared hosting so system calls (mysqldump, etc) are out, also some are on Win32 and others on Linux.
I'm assuming that there is a clever way of doing it without having to select and write each table to a text file or something. I was then planning on using Archive::Zip to compress the backup file.
Help much appreciated.