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:24, 13 May 2012
, 14 years ago→Import dump file
| Line 58: | Line 58: | ||
psql -h name_or_ip_of_postgresql_server -d name_database_postgresql -U login_database_mysql -f mysqldump_readyforpgsql.sql >resimport.log 2>&1 | psql -h name_or_ip_of_postgresql_server -d name_database_postgresql -U login_database_mysql -f mysqldump_readyforpgsql.sql >resimport.log 2>&1 | ||
</source> | </source> | ||
Take a look at output log file resimport.log. If target structure was correctly matching mysql structure (no less tables nor fields), you should get no error. | |||
If you have error, please report them onto dolibarr forum. | |||
Note that you can run this import several time if you fixed error manually to your structure. It is safe because all dolibarr tables are protected by a "unique key". So if you do so, you will just get "duplicate record" errors, that you can ignore. Take care only on others. | |||
* Once import is finished, you must enable constraint check and update all sequences to match imported data. | * Once import is finished, you must enable constraint check and update all sequences to match imported data. | ||
<source lang="bash"> | <source lang="bash"> | ||