changing database from PostgreSQL to MySQL in a Ruby on Rails app

Question

In my current application i am using PostgreSQL Data base,

but I want to change the PostgreSQL database into MYSQL DB.

if it's impossible ?

possible duplicate of Migrate database from Postgres to MySQL — zed_0xff, Jun 16 at 7:01

Siva · Accepted Answer · 2014-06-16 07:43:35Z

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

Rodrigo Zurek · Answer 2 · 2014-06-16 05:44:11Z

this is a duplicate

dont forget to change the gems and your database config file to something like this:

development:
  adapter: mysql2
  encoding: utf8
  database: my_db_name
  username: root
  password: my_password
  host: 127.0.0.1
  port: 3306

2 Answers 2