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 10:48, 10 February 2012
, 14 years ago→Process
| Line 11: | Line 11: | ||
* Choose export method "'''MySql dump'''". | * Choose export method "'''MySql dump'''". | ||
* Choose export compatibility "'''POSTGRESQL'''". | * Choose export compatibility "'''POSTGRESQL'''". | ||
* Uncheck '''Structure'''. | |||
* Check '''Name columns'''. | |||
* Choose '''No LOCK command around INSERT'''. | * Choose '''No LOCK command around INSERT'''. | ||
* Choose "'''Compress None'''" | * Choose "'''Compress None'''" | ||
* Then click on "'''Build backup'''". | |||
* Go into directory of your Dolibarr data files (directory is defined into "'''Setup - System information - Dolibarr - All parameters'''" on line "'''Root directory for data files'''"). | * Go into directory of your Dolibarr data files (directory is defined into "'''Setup - System information - Dolibarr - All parameters'''" on line "'''Root directory for data files'''"). | ||
* Go into subdirectory '''admin/backup'''. You will find the dump of database you just build with previous step. | * Go into subdirectory '''admin/backup'''. You will find the dump of database you just build with previous step. | ||