Re: [GENERAL] Importing MySQL dump into PostgreSQL 8.2

2007-10-15 Thread Alan Hodgson
On Friday 12 October 2007, wido [EMAIL PROTECTED] wrote: hi! but what happens when somebody sent you a dump file and you can't convert the tables? all i have is a 116MB sql file, and i won't convert it by hand :P Restore it into MySQL and then extract it in whatever form you like. Free

Re: [GENERAL] Importing MySQL dump into PostgreSQL 8.2

2007-10-14 Thread wido
On 5 oct, 01:06, [EMAIL PROTECTED] (Chris) wrote: Jeff Lanzarotta wrote: Hello, I have a MySQL dump file that I would like to import into our PostgreSQL 8.2 database. Is there a way to do this? You'll need to convert the table definitions then the data. For example, mysql has int(11)

Re: [GENERAL] Importing MySQL dump into PostgreSQL 8.2

2007-10-14 Thread Andrej Ricnik-Bay
On 10/13/07, wido [EMAIL PROTECTED] wrote: hi! but what happens when somebody sent you a dump file and you can't convert the tables? all i have is a 116MB sql file, and i won't convert it by hand :P And chances are no one on the list will do it for you, either, specially not when you stick out

Re: [GENERAL] Importing MySQL dump into PostgreSQL 8.2

2007-10-04 Thread Chris
Jeff Lanzarotta wrote: Hello, I have a MySQL dump file that I would like to import into our PostgreSQL 8.2 database. Is there a way to do this? You'll need to convert the table definitions then the data. For example, mysql has int(11) columns, postgres only has int columns. I usually

[GENERAL] Importing MySQL dump into PostgreSQL 8.2

2007-10-03 Thread Jeff Lanzarotta
Hello, I have a MySQL dump file that I would like to import into our PostgreSQL 8.2 database. Is there a way to do this? Thanks. -Jeff