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:38, 12 May 2012
, 14 years ago→Import dump file
| Line 33: | Line 33: | ||
<source lang="bash"> | <source lang="bash"> | ||
cd /tmp | cd /tmp | ||
sed -e "s/\\\'/\'\'/g" mysqldump_mydatabase_version_date | sed -e "s/\\\'/\'\'/g" mysqldump_mydatabase_version_date.sql > mysqldump_readyforpgsql.sql | ||
</source> | </source> | ||
* After conversion of file, import it into your empty postgresql database: | * After conversion of file, import it into your empty postgresql database: | ||