29,398
edits
Changes
FAQ Migrate my Mysql database to PostgreSQL (view source)
Revision as of 19:23, 6 May 2012
, 13 years ago→Create a PostGreSQL database
Line 23:
Line 23:
* Create an empty file '''conf.php''' to replace the renamed one, with read and write permission for everybody.
* Create an empty file '''conf.php''' to replace the renamed one, with read and write permission for everybody.
* Run Dolibarr. Because the conf.php file is empty, 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 existing into your MySql sessions.
* Run Dolibarr. Because the conf.php file is empty, 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 existing into your MySql sessions.
−* Connect. You are now into an empty new instance of Dolibarr without old data. We will load them at next step.
+* Connect. You are now into an empty new instance of Dolibarr without old data.
+* Enable all modules that were enabled into old database (enable is enough to create modules specific tables, that's all what we want: having same structure than old database).
+* If you added "complementary fields" for some element, you must also defined them into this new instance (again, to have same fields into database than previous instance).
+* We will load old data at next step.
Note: If you experience problem, you can go back to your Mysql database by restoring files renamed previsously into its original name '''conf.php'''.
Note: If you experience problem, you can go back to your Mysql database by restoring files renamed previsously into its original name '''conf.php'''.