31,003
edits
FAQ Migrate my Mysql database to PostgreSQL: Difference between revisions
Jump to navigation
Jump to search
FAQ Migrate my Mysql database to PostgreSQL (view source)
Revision as of 11:45, 6 May 2012
, 14 years ago→Import dump file
| Line 27: | Line 27: | ||
* Modify the generated file to set escape characters with correct characters: | * Modify the generated file to set escape characters with correct characters: | ||
<source lang="bash"> | <source lang="bash"> | ||
cd /tmp | |||
sed -e "s/\\\'/\'\'/g" mysqldump_mydatabase_version_date.sql > tmpfile.sql | sed -e "s/\\\'/\'\'/g" mysqldump_mydatabase_version_date.sql > tmpfile.sql | ||
sed -e 's/\\/\\\\/g' tmpfile.sql > mysqldump_readyforpgsql.sql | sed -e 's/\\/\\\\/g' tmpfile.sql > mysqldump_readyforpgsql.sql | ||