Rails, how to migrate data from development sqlite3 database to production MySQL database?

Question

With Rails, how do you migrate data from development sqlite3 database to production MySQL database?

How to make it easier?

dexter · Accepted Answer · 2011-09-03 09:43:57Z

18

You should use a gem like YamlDB. Install the Gem and then use the following rake tasks

rake db:data:dump  
RAILS_ENV=production rake db:data:load

The first command dumps the contents of dev database to a file called db/data.yml

Also, please remember that this must be used in addition to rake db:schema:dump|load tasks as this only ports the data assuming the schema is already in place

answered Sep 3, 2011 at 9:43

dexter

13.6k5 gold badges42 silver badges56 bronze badges

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

Comments

KenB · Accepted Answer · 2011-09-03 06:13:35Z

0

Assuming your database configurations are properly set up in config/database.yml, the following should get the database structure set up in production for you.

Runs against development database by default:

rake db:schema:dump

Run this against your production database by virtue of the RAILS_ENV environment variable:

rake RAILS_ENV=production db:schema:load

answered Sep 3, 2011 at 6:13

KenB

6,8072 gold badges38 silver badges34 bronze badges

2 Comments

zolter Over a year ago

It only creates tables, but how to transfer data from these tables?

zolter Over a year ago

And I think It is same that rake db:migrate RAILS_ENV=production.

Collectives™ on Stack Overflow

Rails, how to migrate data from development sqlite3 database to production MySQL database?

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related