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 11:48, 6 May 2012
, 14 years ago→Create a PostGreSQL database
| Line 20: | Line 20: | ||
===Create a PostGreSQL database=== | ===Create a PostGreSQL database=== | ||
* | * Rename conf.php file of Dolibarr into conf.php.mysql (file should be into '''/etc/dolibarr''' or '''htdocs/conf''') | ||
* Run Dolibarr. Because the conf file does not exists anymore, the install process will be suggested. Choose first installation and provide all informations of your postgresql database as data source. Run process until the end. About administrator account asked at end, choose same than the one exisitng into your MySql sessions. | * Run Dolibarr. Because the conf.php file does not exists anymore, the install process will be suggested instead of logon page. Choose first installation and provide all informations of your postgresql database as data source. Run process until the end. About administrator account asked at end, choose same than the one exisitng into your MySql sessions. | ||
Note: If you experience problem, you can go back to your Mysql database by restoring files renamed previsously. | Note: If you experience problem, you can go back to your Mysql database by restoring files renamed previsously into its original name '''conf.php'''. | ||
=== Import dump file === | === Import dump file === | ||