You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2020-02-13 13:48:46

brandhu
Member
Registered: 2020-02-13
Posts: 4

GLPI Database migration

Hi,

Need some help… sad

We have an old GLPI server running on a synology device. (GLPI085.2.2-0023, MariaDB5.5.41-0029, PHP4.3.0-0101)
I installed a new GLPI server on a Windows2016 server. (GLPI9.4.1.1, MySQL5.6)

Is it possible to move the database to the new server?
Can anyone help me with the process?


Thanks

brandhu

Offline

#2 2020-02-13 14:49:40

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 5,030

Re: GLPI Database migration

backup your old database using mysqldump command

drop tables in new glpi database.
restore olddatabase on new server

extract glpi archive on new server  ( use 9.4.5 version, many bug are fixed since 9.4.1.1)

run upgrade


EDIT :  move glpi/files from old to newserver


Trouver la panne avant de réparer...
*GLPI 9.1.6+fusion9.1+1.1+behaviours1.5.0+reports+fields+appliances+pdf+badges+formcreator2.5.2 PHP7.0 Mariadb10
*GLPI 9.4.6(behaviours2.2.1+fusioninventoty 9.4+1.1+applicatifs2.5.0+fields 1.9.1) php7.2 mysql5.6 hebergé sur serveur mutualisé.
TEST GLPI9.5.0   php7.4 mariadb 10.3 ubuntu20.04 en attente migration des plugins compatibles

Offline

#3 2020-02-14 09:49:09

brandhu
Member
Registered: 2020-02-13
Posts: 4

Re: GLPI Database migration

Hi LaDenrée,


Thanks for the Help!

Unfortunately, I got stuck.
I upgraded to 9.4.5
Tables were deleted from the new database.
SQL Dump loaded in new database.
I wanted to update the database in GLPI Setup but I get this error:

GLPI SETUP


Frissítés (Update)

A kapcsolódás az adatbázishoz sikerült. (Connect to database, succeeded)

Database version seems correct (5.6.47) - Perfect!Database version seems correct (5.6.47) - Perfect!


Frissítés 0.85.3 verzióra (Update to 0.85.3 Version)


Adatbázis szerkezet változás : glpi_users (0 másodperc) (Database structure change)

PHP User Warning: Table glpi_users does not exists in C:\inetpub\wwwroot\inc\dbmysql.class.php at line 715

PHP User Warning: Table glpi_projecttasks does not exists in C:\inetpub\wwwroot\inc\dbmysql.class.php at line 715

PHP User Warning: Table glpi_projecttasks does not exists in C:\inetpub\wwwroot\inc\dbutils.class.php at line 457

PHP User Warning: Table glpi_tickets does not exists in C:\inetpub\wwwroot\inc\dbmysql.class.php at line 715

PHP User Warning: Table glpi_problems does not exists in C:\inetpub\wwwroot\inc\dbmysql.class.php at line 715
0.85.3 multiple alter in glpi_users - Hiba az adatbázis lekérdezésekor: ALTER TABLE `glpi_users` ADD `task_state` int(11) DEFAULT NULL - Hiba :Table 'glpi_prod.glpi_users' doesn't exist

Offline

#4 2020-02-14 09:57:57

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 5,030

Re: GLPI Database migration

it looks like your dump (or restore) was not complete, some tables are missing.
do you use mysqldump command ?
do you use phpmyadmin or glpi backup tool ?


Trouver la panne avant de réparer...
*GLPI 9.1.6+fusion9.1+1.1+behaviours1.5.0+reports+fields+appliances+pdf+badges+formcreator2.5.2 PHP7.0 Mariadb10
*GLPI 9.4.6(behaviours2.2.1+fusioninventoty 9.4+1.1+applicatifs2.5.0+fields 1.9.1) php7.2 mysql5.6 hebergé sur serveur mutualisé.
TEST GLPI9.5.0   php7.4 mariadb 10.3 ubuntu20.04 en attente migration des plugins compatibles

Offline

#5 2020-02-14 10:21:41

brandhu
Member
Registered: 2020-02-13
Posts: 4

Re: GLPI Database migration

No, I use in GLPI Administration -> Maintenance Menu.
Where can I download the Backup Tool?

Offline

#6 2020-02-14 10:56:47

LaDenrée
HELPER
Registered: 2012-11-19
Posts: 5,030

Re: GLPI Database migration

I Don't know much about Synology,  but this command should work to get your dump.

mysqldump -u [username] -p [databaseName] > my_glpi_dump.sql


Trouver la panne avant de réparer...
*GLPI 9.1.6+fusion9.1+1.1+behaviours1.5.0+reports+fields+appliances+pdf+badges+formcreator2.5.2 PHP7.0 Mariadb10
*GLPI 9.4.6(behaviours2.2.1+fusioninventoty 9.4+1.1+applicatifs2.5.0+fields 1.9.1) php7.2 mysql5.6 hebergé sur serveur mutualisé.
TEST GLPI9.5.0   php7.4 mariadb 10.3 ubuntu20.04 en attente migration des plugins compatibles

Offline

#7 2020-02-14 15:16:32

brandhu
Member
Registered: 2020-02-13
Posts: 4

Re: GLPI Database migration

Thanks, third dump succeded.

Offline

Board footer

Powered by FluxBB