Rails 3.03 Database from sqlite3 to MySQL

rubyonrails-talk
#1

I have created a shopping cart using the AWD 4 book and now want to
upload it to a server. Is there a straight forward way for me to
export my current sqlite3 database (and its tables and data) into a
MySQL database?

#2

There are others (GIYF) but I've used this one:

http://blog.heroku.com/archives/2007/11/23/yamldb_for_databaseindependent_data_dumps/

HTH,

#3

1- if you want to recreate the schema use

RAILS_ENV=production rake db:load:schema

2- if you want to load initial data do

RAILS_ENV=production rake db:seed

but first fill the seeds.rb file properly

all this should be automatic with Capistrano by creating the proper recipe