Re: [galaxy-dev] MySQL to PostgreSQL migration scripts available here

2011-04-13 Thread Louise-Amélie Schmitt
Hi Leandro :) Someone already asked so I'll just copy the answer I gave him that time. Here it is: On Fri, 8 Apr 2011 16:33:58 -0400, Kanwei Li wrote: > Hi Louise, > > Have you considered doing a SQL dump and import? Sounds easier to me >

Re: [galaxy-dev] MySQL to PostgreSQL migration scripts available here

2011-04-13 Thread Leandro Hermida
Hi Louise, Sorry if this is a bad recommendation and if you already tried it and it doesn't work for Galaxy, but did you know that the MySQL database dump program mysqldump has a feature to dump the entire database properly for import into PostgreSQL? mysqldump --compatible=postgresql [galaxy db

[galaxy-dev] MySQL to PostgreSQL migration scripts available here

2011-04-11 Thread Louise-Amélie Schmitt
Hello everyone I finally managed to finish my two scripts. It's kind of dirty coded (I'm not a Perl fan + I was in a hurry), but at least they worked for me. I could successfully transfer the data from an old MySQL Galaxy to my new PSQL Galaxy. Before running the scripts, you should already have