Rails 3.03 Database from sqlite3 to MySQL

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?

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:

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

HTH,

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

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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs