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
– zed_0xff, Commented Jun 16, 2014 at 7:01

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

7

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

edited Jun 16, 2014 at 7:43

answered Jun 16, 2014 at 7:33

Siva

1114 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Daniel Over a year ago

How to run on Heroku?

Community · Accepted Answer · 2017-05-23 12:16:29Z

0

this is a duplicate

Migrate database from Postgres to MySQL

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

edited May 23, 2017 at 12:16

CommunityBot

11 silver badge

answered Jun 16, 2014 at 5:44

Rodrigo Zurek

4,5759 gold badges36 silver badges45 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related