Convert postgres database to mysql

Question

MySQL

There is a base in pg without triggers, procedures and other things. How can I transfer the structure, data, foreign keys, unique constraints, indexes to mysql? pg_dump produces a lot of incompatible code.

Answer 1

You can't do without a self-written script. On what to write it, decide for yourself, choose what you know better (python, bash). The essence of the task is quite simple - take the sql that pg_dump gave you and replace the DBMS-specific constructs in it. Test on some small table like a reference book. You can probably get by with pure sed .

Answer 2

Google immediately gives a bunch of links to all sorts of tools. try it and you're sure something will work.
ps I was looking for a similar tool to convert mysql to postgres at one time. It took a little over an hour for all the searches and experiments.

Answer 3

in pgdump I think there is a compatibility mode like everywhere else, turn it on and fix minor bugs yourself.