nisham22
6/4/2018 - 6:30 AM

Mysql to Psql

Backup from Mysql

mysqldump --compatible=postgresql --default-character-set=utf8 -u root -p tasks > export.sql

Msql to Psql

wget https://raw.github.com/lanyrd/mysql-postgresql-converter/master/db_converter.py chmod +rx db_converter.py python db_converter.py export.mysql import.psql

Now dump into postgres

sudo -u postgres psql tasks < import.psql