29,276
edits
Changes
FAQ Migrate my Mysql database to PostgreSQL (view source)
Revision as of 10:10, 16 February 2011
, 14 years ago→Process
Line 7:
Line 7:
'''Export Mysql:'''+'''Create a PostGreSQL database'''+'''Modify you Dolibarr setup file'''+'''Test'''+
=Process=
=Process=
−==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 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==
* 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==
−You should now have an application 100% working with all its data.
You should now have an application 100% working with all its data.