The first command will dump the data, then you can do your validations, and finally, the second will restore them. -- H
On Sat, 9 Mar 2019 at 11:31, <brainiacs...@gmail.com> wrote: > Thank you Hassan brilliant. I may not have explained this well. What i > want to do is dump it from the CLI locally and then import the data once it > is validated for compliance purposes. > > On Saturday, March 9, 2019 at 2:16:57 PM UTC-5, hasan...@gmail.com wrote: >> >> Define 2 stanzas in database.yml. One for your postgres database, the >> second for your mysql. "bundle exec rails db:schema:dump >> RAILS_ENV=$POSTGRES_STANZA" will save the data and "bundle exec rails >> db:schema:load RAILS_ENV=$MYSQL_STANZA" will restore it to mysql. Let me >> know if you should require further assistance. -- H >> >> On Sat, 9 Mar 2019 at 11:10, <braini...@gmail.com> wrote: >> >>> Hey Everyone, >>> >>> I need to dump the data from a postgress database in Heroku to a mysql >>> database in Heroku for the Ruby on Rails app that has been upgraded. Can >>> anyone walk me through the process. Ideally I want to dump the data to my >>> machine so there is an offline retention of the change as well. Please >>> advise. >>> >>> >>> Thanks, >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Ruby on Rails: Talk" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to rubyonrails-ta...@googlegroups.com. >>> To post to this group, send email to rubyonra...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/rubyonrails-talk/9dcc62aa-fc44-486f-ac4d-10911cc4848a%40googlegroups.com >>> <https://groups.google.com/d/msgid/rubyonrails-talk/9dcc62aa-fc44-486f-ac4d-10911cc4848a%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> -- >> OpenPGP: >> https://sks-keyservers.net/pks/lookup?op=get&search=0xFEBAD7FFD041BBA1 >> If you wish to request my time, please do so using >> *bit.ly/hd1AppointmentRequest >> <http://bit.ly/hd1AppointmentRequest>*. >> Si vous voudrais faire connnaisance, allez a *bit.ly/hd1AppointmentRequest >> <http://bit.ly/hd1AppointmentRequest>*. >> >> <https://sks-keyservers.net/pks/lookup?op=get&search=0xFEBAD7FFD041BBA1>Sent >> from my mobile device >> Envoye de mon portable >> > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to rubyonrails-talk+unsubscr...@googlegroups.com. > To post to this group, send email to rubyonrails-talk@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/955d5201-ea61-47a6-b6e9-e86eca2986ec%40googlegroups.com > <https://groups.google.com/d/msgid/rubyonrails-talk/955d5201-ea61-47a6-b6e9-e86eca2986ec%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- OpenPGP: https://sks-keyservers.net/pks/lookup?op=get&search=0xFEBAD7FFD041BBA1 If you wish to request my time, please do so using *bit.ly/hd1AppointmentRequest <http://bit.ly/hd1AppointmentRequest>*. Si vous voudrais faire connnaisance, allez a *bit.ly/hd1AppointmentRequest <http://bit.ly/hd1AppointmentRequest>*. <https://sks-keyservers.net/pks/lookup?op=get&search=0xFEBAD7FFD041BBA1>Sent from my mobile device Envoye de mon portable -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscr...@googlegroups.com. To post to this group, send email to rubyonrails-talk@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAP%2BbYWBano0cM0QyxZk_WsYKLCPU2ftB-TSYe1_e%2BRoh4sdbUQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.