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? -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
On Tue, Mar 8, 2011 at 5:25 AM, ubique <info-GDGpm2KffGsk6mLPCLz6vTeXD3sScBsC@public.gmane.org> 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 Schroeder ------------------------ hassan.schroeder-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org twitter: @hassan -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
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 -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.