Migration from MySQL to PostgreSQL

Migration from MySQL to PostgreSQL

by Filip Novák -
Number of replies: 1
Hello,

I have problem with migration from MySQL 5.0.22 to PostgreSQL 8.1.11.
I tried to make clean installation of 1.9 version and than mysqldump (only data) and import into PostgreSQL:

mysqldump database -v -nt --compatible=ansi,postgresql --complete-insert=TRUE --extended-insert=FALSE --compact --default-character-set=UTF8 -u user -p -r pg_database

psql database < pg_database.sql
but it seems not good.

a) very long time of import into PostgreSQL
b) DB size in MySQL 800MB - in PostgreSQL 2GB
c) after import shows Moodle messages "Could not save your course display!"

Thank you for any suggestions.

Filip
Average of ratings: -
In reply to Filip Novák

Re: Migration from MySQL to PostgreSQL

by Filip Novák -
a) solution is use transaction - BEGIN; at the start and COMMIT; at the end of dump file
Average of ratings: Useful (1)