5 Sep
2012
5 Sep
'12
2:24 a.m.
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