This repository was archived by the owner on Jun 24, 2018. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 2
Rails plugin to add sql dump and restore tasks
License
osteele/db_content
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
= DB Content Plugin
The DB Content plugin for Rails adds tasks to save and restore
database content.
== Usage
# dump the development database to db/archive/development-content.sql.gz
$ rake db:content:dump
# load the dumped database, and apply any necessary migrations
$ rake db:content:load
# dump the production database to db/archive/production-content.sql.gz
$ RAILS_ENV=production rake db:content:dump
# save the development database to db/archive/{timestamp}.sql.gz
$ rake db:content:save
# save the (compressed) database to my-data.sql.gz
$ rake db:content:save FILE=my-data.sql.gz
# save the (uncompressed) database to my-data.sql
$ rake db:content:save FILE=my-data.sql
# load the database from my-data.sql
$ rake db:content:load FILE=my-data.sql
== Tasks
rake db:content:archive
Saves a timestamped database to db/archive/#{timestamp}.sql.gz
rake db:content:dump
Dumps the database to FILE or db/#{RAILS_ENV}-content.sql.gz. If FILE
ends in .gz, the file is compressed.
rake db:content:load
Loads the database from FILE or db/#{RAILS_ENV}-content.sql.gz, and
migrates it to the current schema version. If FILE ends in.gz, the
file is piped through gunzip.
== Installation
To install from the top level of a Rails application:
git clone git://github.com/osteele/db_content.git vendor/plugins/db_content
If you're running off Edge Rails (or, presumably, Rails > 2.0.2), you
should be able to do this instead:
script/plugin install git://github.com/osteele/db_content
== Limitations
The plugin works only with the MySQL databases. (It adds methods to the Mysql adaptor; see the source.) The gzip option probably only works on *nix (MacOS, Linux, etc.).
== License
Copyright (c) 2006-2008 by {Oliver Steele}[http://workingwithrails.com/person/12359-oliver-steele]. Released under the MIT license.
About
Rails plugin to add sql dump and restore tasks
Topics
Resources
License
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published