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(a)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_Postgr...
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