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 16:11, 13 May 2012
, 14 years ago→Export Mysql
| Line 23: | Line 23: | ||
* Uncheck "'''Use extended INSERT'''". | * Uncheck "'''Use extended INSERT'''". | ||
* Choose "'''No LOCK command around INSERT'''". | * Choose "'''No LOCK command around INSERT'''". | ||
* | * Into '''Compression''' area, choose "'''Compress None'''" | ||
* Then click on "'''Build backup'''". | * 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 subdirectory '''admin/backup'''. You will find the dump of database you just build with previous step. Copy this file into /tmp directory. | * 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. Copy this file into /tmp directory. | ||