<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Hi Andy<div><br></div><div>I used this successfully recently: <a href="https://github.com/philipsoutham/py-mysql2pgsql/">https://github.com/philipsoutham/py-mysql2pgsql/</a></div><div><br></div><div>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.</div><div><br></div><div>I also failed to find anything that wasn’t beta-ish, but this worked OK for my case. YMMV of course.</div><div><br></div><div>HTH</div><div><br></div><div>Matt</div><div><br></div><div><br></div><div><br><div><div>On 4 Mar 2014, at 11:12, Andrew Stewart <<a href="mailto:boss@airbladesoftware.com">boss@airbladesoftware.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite">Hello LRUG,<br><br>What's the current best way to migrate data from MySQL to Postgres? Everything I've found seems to be somewhat, er, "beta".<br><br>Thanks in advance,<br><br>Andy Stewart<br><br>_______________________________________________<br>Chat mailing list<br><a href="mailto:Chat@lists.lrug.org">Chat@lists.lrug.org</a><br>http://lists.lrug.org/listinfo.cgi/chat-lrug.org<br></blockquote></div><br></div></body></html>