Backing up mysql using cron job

[scifind]

Tweet

Hi
I want to do a daily backup of my mysql databases - can any one give me the command to use in a cron job to achiven this?

[mxp]

Having just spent the last couple of hours trying to achieve pretty much the same thing i have just this minute managed to get it working. the command i finally got working was this (this puts the backup file file_name.sql into my root folder)

mysqldump --all-databases --user=username --password = password > file_name.sql

if your having difficulty getting your mysqldump to work try

mysqldump --help > file_name.sql

and that should hopefully give you the list of commands available for your particular version of mysqldump (download and read file_name.sql)