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:

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