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 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

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 ha

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 conver

[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