Rails 3.03 Database from sqlite3 to MySQL

Rails
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

On Tue, Mar 8, 2011 at 5:25 AM, ubique [email protected] wrote:

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?

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

HTH,

Hassan S. ------------------------ [email protected]
twitter: @hassan

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