Thank you Hassan. On Saturday, March 9, 2019 at 2:37:03 PM UTC-5, hasan...@gmail.com wrote: > > 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, <braini...@gmail.com <javascript:>> 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-ta...@googlegroups.com <javascript:>. >> To post to this group, send email to rubyonra...@googlegroups.com >> <javascript:>. >> 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/44baf1b7-7a83-4679-b3ed-476bbd0a26ab%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.