How to import Production Data from Development Database?

Question

Recently, I learn to develop a rails application. Now, I have a problem. I want to change into Production Mode. But I don't want to copy my data in development database manually. How should I do these easily? I use mysql and Mac os and rails 3 beta.

Answer 1

Here are the basic commands for dumping/loading DBs in mysql:

Dumping the database:

$ mysqldump your_dev_db_name > your_db_dump.sql

Loading the dump:

$ mysql your_production_db_name < your_db_dump.sql