Rails Project PostgreSQL to MySQL

gistfile1.txt

Step 1

Make a backup copy of your data

For Rails 3, install the YAML DB gem: https://github.com/ludicast/yaml_db

For Rails 2.x install the YAML DB plugin:

script/plugin install git://github.com/adamwiggins/yaml_db.git

Run the dump task

rake db:dump

Step 2

Update your config/database.yml file.

Step 3 :

gem install mysql

Have rake create your database

rake db:create

rake db:schema:load

Step 4

Use YamlDb to reload your data into MySql

rake db:load