WordPress MU

Hi,

Would anybody share their mysql backup cron job script (minus their db details). there are some available on the net, but just can't trust them.

Cheers

Gotta admit that I just use CPanel's database backup every so often. I run optimize first to get it as small as possible. 190 megs currently.

Haven't tried this but i'm told its reliable and safe

http://sourceforge.net/projects/automysqlbackup/

I wanted to automate it. I have set up Cpanel to use automysqlbackup. Will report back tomorrow.

Let me know how you get on with it. Its supposed to be very good.

mysqldump -u <USERNAME> -p<PASSWORD> -h <HOSTNAME> <DATABASENAME> > <FILENAME>.sql

Replace the brackets and the content inside the brackets with your info.

You can omit the "-h <HOSTNAME>" if you use localhost

For more options and details: man mysqldump

Then just set up your cron job to run.