Dear all, After playing with several different tools, I got the conversion working by using this python program: http://pypi.python.org/pypi/py-mysql2pgsql Just follow the program manual. Both the installation and the execution are quite straight forward. Hope this may help someone in future. Cheers, Leon On Tue, Sep 4, 2012 at 10:54 PM, Leon Mei <hailiang.mei@nbic.nl> wrote:
Dear list members,
Did anyone migrate the Galaxy database from MySQL to Postgres lately? Any verified script available? Simple solution by adding a postgres flag in mysqldump (http://dev.list.galaxyproject.org/MySQL-2-Postgres-td4139570.html) didn't work for me. It throws lots of syntax errors on int(), double quote, etc.
My mysql version: 14.14, distribution 5.5.25a My postgres version: 9.1
I am now on a quest following the suggested list at: http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQ...
I appreciate if someone can share his or her experience on this.
Thanks a lot, Leon
-- Hailiang (Leon) Mei Netherlands Bioinformatics Center BioAssist NGS Taskforce - http://ngs.nbic.nl Skype: leon_mei Mobile: +31 6 41709231
-- Hailiang (Leon) Mei Netherlands Bioinformatics Center BioAssist NGS Taskforce - http://ngs.nbic.nl Skype: leon_mei Mobile: +31 6 41709231