29,232
edits
Changes
FAQ Migrate my Mysql database to PostgreSQL (view source)
Revision as of 10:11, 16 February 2011
, 14 years ago→Process
Line 7:
Line 7:
=Process=
=Process=
−==Export Mysql==
+===Export Mysql===
* Go onto page Setup - Tools - Backup.
* Go onto page Setup - Tools - Backup.
* Choose export method "MySql dump".
* Choose export method "MySql dump".
Line 16:
Line 16:
* 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.
−==Create a PostGreSQL database==
+===Create a PostGreSQL database===
* Create an empty PostGreSQL database
* Create an empty PostGreSQL database
* Import the MySql dump file into the new PostgreSql database by this way ...
* Import the MySql dump file into the new PostgreSql database by this way ...
{{ToComplete}}
{{ToComplete}}
−==Modify you Dolibarr setup file==
+===Modify you Dolibarr setup file===
* Open with a file editor, the file conf/conf.php that you can find into your Dolibarr root installation.
* Open with a file editor, the file conf/conf.php that you can find into your Dolibarr root installation.
* Modify lines make programs to point to new database
* Modify lines make programs to point to new database
Line 33:
Line 33:
</source>
</source>
−==Test==
+===Test===
You should now have an application 100% working with all its data.
You should now have an application 100% working with all its data.