MySQL Tasks plugin

Plugin details

Some rake tasks to automate common database tasks (create/destroy & backup/restore).

Websitehttp://synthesis.sbecker.net/articles/2006/12/10/new-plugin-mysql-tasks Repositoryhttp://sbecker.net/shared/plugins/mysql_tasks/ Author Scott Becker Tags mysql, task LicenseUnknown

Documentation

Install the plugin: 
ruby script/plugin install http://sbecker.net/shared/plugins/mysql_tasks/

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.

Further Documentation

There is currently no advanced documentation for this plugin.

New documentation

Edit plugin | (0 older versions) | Last edited by: hardway, 7 months ago