scheduled backups

[cleary1981]

Hi,

I am not familiar with backing up mysql. I understand the mysqldump tool can be used with php somehow and also that there are several free tools available. Can anyone advise me on which is the best way forward perhaps there is another method.

[coolsti]

I work with Linux but maybe the same can be set up on Windows as well.

I use mysqldump to make a text dump of my entire database, and I save the information to a file that has the current date as part of the file name.

I call the script that performs the mysqldump as part of a cron job once each night. If you are not a Linux user, a cron job is just a batch job which is scheduled to be performed according to how often I set it up, and I set mine up to run each night when most people should be sleeping or partying.

In my case, the mysqldump is called from a shell script, which is invoked by the cron job.

Surely you could set up the same with Windows, I just do not know much about running batch jobs on Windows.

[Atli]

On Windows you would use Task Scheduler. (Check out this article)