Railsy way to Export Database Schema?

bitsweat · August 28, 2006, 7:48pm

Sure:

cd /path/to/myapp

rake db:schema:dump

cp db/schema.rb /path/to/otherapp/db/ cd /path/to/otherapp rake db:schema:load

jeremy

bitsweat · August 29, 2006, 7:26pm

Yes - it’s fixed in MySQL 5.1 maybe?

Kidding. If you’re moving between two MySQLs, set the schema dump format to :sql in config/environment.rb. That’ll give you a ‘native’ schema dump.

jeremy

bphogan · August 29, 2006, 8:43pm

I know you asked for a “rails” way to do it… but gee… mysqldump is so easy.

bitsweat · August 29, 2006, 9:29pm

Too true! Good point, Brian.

jeremy

Benjamin_Gorlick · August 29, 2006, 10:29pm

Explains backups for mysql, postgresql and sqlite on both linux and windows.

bitsweat · August 29, 2006, 11:44pm

I can’t tell whether you’re into Rails or driving google ad revenue.

jeremy