How to transfer data from Postgres to Mysql?

A

aliasst2018-03-09 21:42:58

Database

aliasst, 2018-03-09 21:42:58

There is a Postgres dump, in the dump there is only data in the form of INSERTs, how to recode this data so that it is suitable for Mysql?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

M

Melkij, 2018-03-09
@melkij

If you have only inserts in the dump (and it is they, not copy; for example, after pg_dump --inserts --data-only) - then try to import into mysql as is.
Perhaps sql_mode will need to be corrected in ANSI quotes, and the data seems to move correctly.
Well, or make dumps in csv - copy commands in postgresql and load data infile in mysql.