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 10:11, 16 February 2011
, 15 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. | ||