Plugin details

YamlDb is a database-independent format for dumping and restoring data. It complements the the database-independent schema format found in db/schema.rb. The data is saved into db/data.yml.

This can be used as a replacement for mysqldump or pg_dump, but only for the databases typically used by Rails apps. Users, permissions, schemas, triggers, and other advanced database features are not supported - by design.

Any database that has an ActiveRecord adapter should work.

Websitehttp://opensource.heroku.com/ Repositorygit://github.com/adamwiggins/yaml_db.git Author Orion Henry, Adam Wiggins Tags YAML, rake LicenseRuby's (MIT)

Documentation

Install the plugin: 
ruby script/plugin install git://github.com/adamwiggins/yaml_db.git
rake db:data:dump   #   Dump contents of Rails database to db/data.yml
rake db:data:load   #   Load contents of db/data.yml into the database



Further, there are tasks db:dump and db:load which do the entire database (the equivalent of running db:schema:dump followed by db:data:load).

== Examples

One common use would be to switch your data from one database backend to another. For example, let's say you wanted to switch from SQLite to MySQL. You might execute the following steps:

1. rake db:dump

2. Edit config/database.yml and change your adapter to mysql, set up database params

3. mysqladmin create [database name]

4. rake db:load

Further Documentation

There is currently no advanced documentation for this plugin.

New documentation

Edit plugin | Back in time (2 older versions) | Last edited by: scott, 4 months ago