Database dump and import

[braini...@gmail.com]

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,

[Hasan Diwan]

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

--
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.
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.

Si vous voudrais faire connnaisance, allez a bit.ly/hd1AppointmentRequest.

Sent from my mobile device

Envoye de mon portable

[braini...@gmail.com]

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.

[Hasan Diwan]

The first command will dump the data, then you can do your validations, and finally, the second will restore them. -- H

To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/955d5201-ea61-47a6-b6e9-e86eca2986ec%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[braini...@gmail.com]

Thank you Hassan. 

[Rob Jonson]

bundle exec rails db:schema:dump

does this dump the data, or just the schema?

I would assume just the schema - and that to transfer the data you'll need to use something like the solutions here:

https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL 

[Walter Lee Davis]

Just the schema. For the data, you'd need to run a backup utility of some sort. On MySQL, there's mysqldump, I'm pretty sure there's similar on the Postgres side, so no matter which direction you want to go, you'd be set. Be sure to only dump the data, not the structure, if you're using the schema:dump technique. Rails' database adapters are smart, and they can do the exact same structure with all the local weirdnesses that are required by the respective engines.

Walter

> --
> 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/5fcb6342-219a-41d8-882b-1ada28ffff8d%40googlegroups.com.

[braini...@gmail.com]

Correct Walter. I have the data. I have to do a conversion and then it is all set.