L
L
Lisio2012-06-30 23:22:42
MySQL
Lisio, 2012-06-30 23:22:42

How can I convert a mysql dump to pgsql under Linux?

In the official wiki, half of the utilities work with errors, the other half no longer exist at all.

Answer the question

In order to leave comments, you need to log in

3 answer(s)
N
Nazar Mokrinsky, 2012-07-01
@nazarpc

In PhpMyAdmin, there is an option in the import to be compatible with different versions and types of dumps.
As far as I know, there is PgMyAdmin (I saw it in the repository, I didn’t install it, I tried it), maybe it has a similar option?

J
Jodes, 2012-07-02
@Jodes

mysqldump -u user -ppassword --compatible=postgresql database

S
sapun, 2012-07-02
@sapun

github.com/maxlapshin/mysql2postgres - great stuff!

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question