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 02:24, 19 February 2012
, 14 years ago→Import dump file
| Line 30: | Line 30: | ||
sed -e 's/\\/\\\\/g' tmpfile.sql > mysqldump_readyforpgsql.sql | sed -e 's/\\/\\\\/g' tmpfile.sql > mysqldump_readyforpgsql.sql | ||
</source> | </source> | ||
* | * After conversion of file, import it into your empty postgresql database: | ||
<source lang="bash"> | <source lang="bash"> | ||
psql -h name_or_ip_of_postgresql_server -d name_database_postgresql -U login_database_mysql -f mysqldump_readyforpgsql.sql | psql -h name_or_ip_of_postgresql_server -d name_database_postgresql -U login_database_mysql -f mysqldump_readyforpgsql.sql > /tmp/resimport.log | ||
</source> | |||
* Once import is finished, you must update all sequences to match imported data. | |||
<source lang="bash"> | |||
psql -h name_or_ip_of_postgresql_server -d name_database_postgresql -U login_database_mysql | |||
# select rebuilt_sequences(); | |||
CTRL+D | |||
</source> | </source> | ||