[LRUG] MySQL to Postgres

[Matt Gibson]

Hi Andy

I used this successfully recently: https://github.com/philipsoutham/py-mysql2pgsql/

Some columns didn’t have the correct defaults set afterwards, and I had to delete an index or two (corrupted somehow) for the import to work, but it was painless otherwise for a ~4GB dataset.

I also failed to find anything that wasn’t beta-ish, but this worked OK for my case. YMMV of course.

HTH

Matt



On 4 Mar 2014, at 11:12, Andrew Stewart <boss at airbladesoftware.com> wrote:

> Hello LRUG,
> 
> What's the current best way to migrate data from MySQL to Postgres?  Everything I've found seems to be somewhat, er, "beta".
> 
> Thanks in advance,
> 
> Andy Stewart
> 
> _______________________________________________
> Chat mailing list
> Chat at lists.lrug.org
> http://lists.lrug.org/listinfo.cgi/chat-lrug.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lrug.org/pipermail/chat-lrug.org/attachments/20140304/c3450440/attachment-0003.html>