29,402
edits
Changes
FAQ Migrate my Mysql database to PostgreSQL (view source)
Revision as of 19:13, 6 May 2012
, 13 years ago→Import dump file
Line 39:
Line 39:
* Once import is finished, you must update all sequences to match imported data.
* Once import is finished, you must update all sequences to match imported data.
<source lang="bash">
<source lang="bash">
−psql -h name_or_ip_of_postgresql_server -d name_database_postgresql -U login_database_mysql >load.sql 2>&1
+psql -h name_or_ip_of_postgresql_server -d name_database_postgresql -U login_database_mysql
# select rebuilt_sequences();
# select rebuilt_sequences();
CTRL+D
CTRL+D