Skip to content

Instantly share code, notes, and snippets.

@barseghyanartur

barseghyanartur/convert_mysql_dump_to_postgresql_dump.md

Created June 11, 2020 14:21
Show Gist options
  • Save barseghyanartur/56876ab3acbd3d5d6ab7dcc477c29238 to your computer and use it in GitHub Desktop.
Save barseghyanartur/56876ab3acbd3d5d6ab7dcc477c29238 to your computer and use it in GitHub Desktop.
Download ZIP
Convert MySQL dump to PostgreSQL dump
Raw
convert_mysql_dump_to_postgresql_dump.md

Prepare database dump using mysqldump:

mysqldump -u [username] -p [databaseName] --compatible=postgresql --default-character-set=utf8 > database.sql

Clone mysql-postgresql-converter project:

git clone [email protected]:lanyrd/mysql-postgresql-converter.git
cd mysql-postgresql-converter

Assuming that your mysql/mariadb dump is named database.sql, place that file into the mysql-postgresql-converter directory.

Convert mysql dump to postgresql dump:

python db_converter.py database.mysql database.psql

Replace datetime field with timestamp field.

sed -i 's/datetime(6)/timestamp with time zone/' database.psql

Import dump into postgres:

psql -U dbname -f database.pgsql
@pradeshc
Copy link

pradeshc commented Mar 4, 2025 •
edited
Loading

pg loader

pgloader mysql://root:[email protected]/dbname pgsql://postgres:[email protected]/dbname

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment