Agile Web Development

Build it. Launch it. Love it.

MySQL Tasks

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.

Vitals

Home http://synthesis.sbecker.net/articles/2006/12/10/new-plugin-mysql-tasks
Repository http://sbecker.net/shared/plugins/mysql_tasks
License Rails' (MIT)
Rating (4 votes)
Owner Scott Becker
Created 10 December 2006

Comments

Add a comment