Agile Web Development

Some rake tasks to automate common database tasks (create/destroy & backup/restore).
Components
rake db:mysql:create # Create database (using database.yml config)
rake db:mysql:destroy # Destroy database (using database.yml config)
rake db:mysql:backup # Dump schema and data to an SQL file (/db/backup_YYYY_MM_DD.sql)
rake db:mysql:restore # Load schema and data from an SQL file (/db/restore.sql)
Specifying RAILS_ENV works if you want to perform operations on test or production databases.

Owner: Scott Becker

Home: http://synthesis.sbecker.net/articles/2006/12/10/new-plugin-mysql-tasks

Repository: http://sbecker.net/shared/plugins/mysql_tasks

License: Rails' (MIT)

Category: Misc. Enhancements