Re: [GENERAL] I need to load mysql dump to postgres...

2011-10-13 Thread Rich Shepard
On Thu, 13 Oct 2011, unclebob wrote: Looks like it's not exactly what I need. It migrates data from db to db, but I need to get data from a file(mysql dump) and load it to postgres. It's a large file and I don't want to load it to mysql first and then migrate data. thanks. When you write, "m

Re: [GENERAL] I need to load mysql dump to postgres...

2011-10-13 Thread unclebob
On 10/13/2011 05:31 AM, Devrim GÜNDÜZ wrote: On Wed, 2011-10-12 at 20:12 -0400, unclebob wrote: I'm under debian squeeze and pgsql 8.4. Do you know which version of mysqlmigrator I can try? Just download the tarball from EDB website, extract it, and run: ant compile ant dist java -jar dist/

Re: [GENERAL] I need to load mysql dump to postgres...

2011-10-13 Thread Devrim GÜNDÜZ
On Wed, 2011-10-12 at 20:12 -0400, unclebob wrote: > > > I'm under debian squeeze and pgsql 8.4. Do you know which version of > mysqlmigrator I can try? Just download the tarball from EDB website, extract it, and run: ant compile ant dist java -jar dist/MigrationWizard.jar openjdk will just

Re: [GENERAL] I need to load mysql dump to postgres...

2011-10-12 Thread unclebob
On 10/12/2011 03:45 AM, Devrim GÜNDÜZ wrote: On Tue, 2011-10-11 at 22:37 -0400, unclebob wrote: Is there a program which would just parse mysql dump file and load data to postgresql using plain sql inserts? EDB has an open source and free tool for this: http://www.enterprisedb.com/migrationw

Re: [GENERAL] I need to load mysql dump to postgres...

2011-10-12 Thread Devrim GÜNDÜZ
On Tue, 2011-10-11 at 22:37 -0400, unclebob wrote: > Is there a program which would just parse mysql dump file and load > data to postgresql using plain sql inserts? EDB has an open source and free tool for this: http://www.enterprisedb.com/migrationwizard-11 If you are using RPM based distros,

Re: [GENERAL] I need to load mysql dump to postgres...

2011-10-11 Thread Craig Ringer
On 10/12/2011 10:37 AM, unclebob wrote: good noon, subj. I don't want to load dump to mysql etc... Is there a program which would just parse mysql dump file and load data to postgresql using plain sql inserts? There's no single, simple automatic migration tool. Numerous tools exist to help. Se

[GENERAL] I need to load mysql dump to postgres...

2011-10-11 Thread unclebob
good noon, subj. I don't want to load dump to mysql etc... Is there a program which would just parse mysql dump file and load data to postgresql using plain sql inserts? thanks. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://ww