Thread: Importing MySQL dump into PostgreSQL 8.2

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

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/

On 5 oct, 01:06, dmag...@gmail.com (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) 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 tutorialshttp://www.designmagick.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

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

On 10/13/07, wido <wido.gg@gmail.com> 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 your tongue
at them ...

Use sed or awk, then, or write a perl script...

Others have done similar things, and made their work available.
Have a search on freshmeat or gborg.


Cheers,
Andrej

On Friday 12 October 2007, wido <wido.gg@gmail.com> 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
Software is a wonderful thing.

--
Ghawar is dying