Re: [galaxy-dev] Migrate Galaxy database from MySQL to Postgres

2012-09-11 Thread Leon Mei
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.

[galaxy-dev] Migrate Galaxy database from MySQL to Postgres

2012-09-04 Thread Leon Mei
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