Crontab and MySQL backup

[petesmc]

How would i do a database dump for a MySQL databse using crontab every midnight?

0 0 * * * ???

[JohnM]

I use:

0 0 * * * mysqldump --opt --user=[HR username]_[mysql account] --password=[password] [database name] > /path/to/file.sql

[DarkWizard]

JohnM....may I use this in the "How Do I?" forum?

[petesmc]

Even though i didn't write this, i click your profile because i was going to ask you to put this into the How do I forum.


I clicked your pofile to email you and saw this was your last thread so i clicked on it and ...

You had already suggested it...