29,232
edits
Changes
FAQ Migrate my Mysql database to PostgreSQL (view source)
Revision as of 16:54, 12 May 2012
, 13 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">