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....@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_PostgreSQL#Scripts.2C_programs > > 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 ___________________________________________________________ Please keep all replies on the list by using "reply all" in your mail client. To manage your subscriptions to this and other Galaxy lists, please use the interface at: http://lists.bx.psu.edu/