Hi,

what is the best way to keep backups of the site content including MYSQL databases?

We plan to install some portal software, where the .html is quite static, but daily data is stored in mySQL tables.

This scenario will be accross our accounts and our client accounts.

Can we run a job that will back the files/DB up at a certain time each night?

We can then DL those files via FTP to our machine offline?

Is there an automated way to do all this using PHP or similar scripting?

cheers!!!

Brian

Yes. There is a command called mysqldump which will put your database in a dumpfile. You can then setup a cronjob to FTP the file over to a different machine.

Is the machine that you will be backing up onto Windows or Unix?

Originally posted by Vincent Paglione
Yes. There is a command called mysqldump which will put your database in a dumpfile. You can then setup a cronjob to FTP the file over to a different machine.

Is the machine that you will be backing up onto Windows or Unix?

I presume the dumpfile will handle the binary data in the database, and will be as big, if not bigger than the database being dumped?

Would like to download the images to my Windows machine from the webhost (Unix)

B

Originally posted by brianc


I presume the dumpfile will handle the binary data in the database, and will be as big, if not bigger than the database being dumped?

Would like to download the images to my Windows machine from the webhost (Unix)

B

Correct, the dumpfile will contain the entire database.

Do you want to download the dump to your windows machine automatically, or with human intervention? Having it download automatically would be quite difficult, unless you can setup a FTP server on your Windows computer and have your Unix machine ftp the dump file onto your Windows box.

Any other ideas?