31,003
edits
FAQ Migrate my Mysql database to PostgreSQL: Difference between revisions
FAQ Migrate my Mysql database to PostgreSQL (view source)
Revision as of 16:54, 12 May 2012
, 14 years ago→Import dump file
| Line 30: | Line 30: | ||
=== Import dump file === | === Import dump file === | ||
* Modify postgresql configuration to accept syntax from mysql file by setting the directive escape_string_warning to off into file '''postgresql.conf''' | |||
<source lang="ini"> | |||
escape_string_warning = off | |||
</source> | |||
Restart postgresql. | |||
* Modify the generated export dump file to set escape characters with correct value for postgres: | * Modify the generated export dump file to set escape characters with correct value for postgres: | ||
<source lang="bash"> | <source lang="bash"> | ||