Is there a rake task for backing up the data in yo

Question

Is there a rake task for backing up the data in your database?

I already have my schema backed up, but I want to make a backup of the data. It's a small MySQL database.

Answer 1

Make sure to add the "--routines" parameter to mysqldump if you have any stored procs in your database so it backs them up too.