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 19:13, 6 May 2012
, 14 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 | 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 | ||