All geek questions in one place

Convert PostgreSQL Database to MySQL

I saw questions for the opposite, but I have a PostgreSQL 800 MB database that needs to be converted to MySQL. I assume this is possible (anything is possible!), And I would like to know the most effective way to get around this and any common errors that need to be looked for. I have no experience with Postgre. Any links to guides on this subject will also be helpful! Thank you

+3
source share
3 answers

We advise you to start with the current version of MySQL, otherwise you will not have sub-queries, stored procedures or views. Another obvious difference is auto increment fields. Departure:

pg2mysql

/ Allan

+6
source

, , . - MySQL - , Postgres - concurrency. Postgres, .

+4

pg_dump can dump as insert statements and create table instructions. That should shut you down. However, the big question is why you want to switch. You can do a lot of work and not get any real benefit from it.

+2
source

Source: https://habr.com/ru/post/1697277/

More articles:


All Articles