Difference between revisions of "FAQ Migrate my Mysql database to PostgreSQL"
Jump to navigation
Jump to search
| 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. | ||
Revision as of 10:11, 16 February 2011
Prerequisite
Your Dolibarr version must be at least version 2.9.0. If not, first upgrade your Dolibarr keeping MySql.
Process
Export Mysql
- Go onto page Setup - Tools - Backup.
- Choose export method "MySql dump".
- Choose export compatibility "POSTGRESQL".
- Choose "Compress None" and click on "Build backup".
- Go into directory of your Dolibarr data files (directory is defined into "Setup - System information - Dolibarr - All parameters" on line "Root directory for data files").
- 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
- Import the MySql dump file into the new PostgreSql database by this way ...
|
|
Page waiting to complete. To complete, create an account, go back and clic on "Modify".
Page en attente d'être complété. Pour compléter, créez un compte, revenez et cliquez sur "Modifier".
Página a completar. Para completarla, cree una cuenta, vuelva a la página y haga clic en "editar"
Seite wartet auf Vervollständigung. Um zu helfen, erstelle ein Konto, gehe zurück und klicke auf "Bearbeiten".
Modify you Dolibarr setup file
- 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
$dolibarr_main_db_host='name_or_ip_of_postgresql_server';
$dolibarr_main_db_port='port_server_postgresql';
$dolibarr_main_db_name='name_database_postgresql';
$dolibarr_main_db_user='login_database_mysql';
$dolibarr_main_db_pass='password_database_mysql';
$dolibarr_main_db_type='pgsql';
Test
You should now have an application 100% working with all its data.