29,232
edits
Changes
FAQ Migrate my Mysql database to PostgreSQL (view source)
Revision as of 10:48, 10 February 2012
, 13 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'''" and click on "'''Build backup'''".
+* 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.