I'm trying to get migrate data from a postgre db into mysql (mariaDB) and was wondering if it is possible to restore a db in mysql from a pgsql dump?
Mysql – Is it possible to dump a postgresql db and restore it in thesql
databasedatabase-backupMySQLpostgresql
Related Topic
- Mysql – Restoring MySQL dump – ERROR 2006 (HY000)
- MySQL Dump Viewer
- Mysql – Most reliable MariaDB to Postgres dump method
- Azure – Unable to restore postgresql data dump for Django app hosted on Azure VM
- MySQL – Fix mysqldump Unknown Table ‘COLUMN_STATISTICS’ Error
- MariaDB – Importing Old MySQL Database Dump into Docker Container Fails
Best Answer
No, it isn't.
You need to do a
--schema-only
dump and hand-convert the schema, then do a--data-only --inserts
dump and use a text-processing tool to remove/replace any PostgreSQL-specific code.Alternately, use an ETL tool like Pentaho Kettle or Talend.