MySQL backups

[Rick]

I've got to look after soem mySQL databases now at work. Can anyone recommend some software can I use to schedule a backup of the databases over night? I've got the mySQl Administrator program downloaded and installed but the backup scheduler doesn't seem to work :S

Cheers

Ric

 

[MikeDX]

Rick, if you can get to a console

mysql-dump -u root --all-databases -p > backup.sql

that should do the trick

 

[Daz]

If you using a proper OS, just crontab that command.. (but with no - in mysqldump )

Or, just use www.bacula.org and backup the system

 

[MikeDX]

Ah, cheeers Daz, I was going from memory