I finally got of loader working. Required a recompile with a flag to increase heap. Because closure I guess.
Awesome part — a MySQL dB that takes 10 min to backup w mysqldump takes about 1 minute w Pgloader. On Tue, Apr 23, 2019 at 2:09 PM Xavier Lange <[email protected]> wrote: > Perhaps you can use rails to read the data from mysql, write it out a file > (maybe in a JSON format? one line per record?). Then in another rails > process, connected to postgres, write that data back out. > > Xavier > > On Apr 23, 2019, at 4:52 PM, Ylan Segal <[email protected]> wrote: > > On Tue, Apr 23, 2019 at 1:44 PM Peter Fitzgibbons < > [email protected]> wrote: > >> Hello folks, >> >> I having a really rough time migrating a mysql 5.6 db to postgres 10.5. >> > > How large is your data set? Can you tolerate downtime? > > It's hard to give advice without knowing more. The simplest I can think of > is exporting to CSV and importing to the other database. It would probably > mean importing without foreign_key constraints and then adding them later. > > >> Have tried all these tools with no success: >> * pgloader >> * pg_chamelion (can't even get it started... someone have a how-to ?) >> * Multiple scripts from the official pg docs : >> https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#MySQL >> > > What didn't work with these approaches? > > -- > -- > SD Ruby mailing list > [email protected] > http://groups.google.com/group/sdruby > --- > You received this message because you are subscribed to the Google Groups > "SD Ruby" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > > > -- > -- > SD Ruby mailing list > [email protected] > http://groups.google.com/group/sdruby > --- > You received this message because you are subscribed to the Google Groups > "SD Ruby" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Thanks and Kindest Regards, Peter Fitzgibbons (224) 307-9689 -- -- SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby --- You received this message because you are subscribed to the Google Groups "SD Ruby" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
