Re: Importing MySQL dump into PostgreSQL 8.2 - Mailing list pgsql-general

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 convert the tables, then do a csv dump from mysql:

select * from table into outfile '/path/to/file';

then import into postgres:

\copy table from '/path/to/file'

--
Postgresql & php tutorials
http://www.designmagick.com/