Migration from MySQL to PostgreSQL

Migration from MySQL to PostgreSQL

av Filip Novák -
Antall svar: 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
Gjennomsnittlig vurdering: -
Som svar til Filip Novák

Re: Migration from MySQL to PostgreSQL

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