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_meiMobile: +31 6 41709231
--
Hailiang (Leon) Mei
Netherlands Bioinformatics Center
BioAssist NGS Taskforce
- http://ngs.nbic.nl
Skype: leon_meiMobile: +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/
