You are not logged in.
Pages: 1
Hi,
Need some help…
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
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...
GLPI10.0.10 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6
Offline
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
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...
GLPI10.0.10 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6
Offline
No, I use in GLPI Administration -> Maintenance Menu.
Where can I download the Backup Tool?
Offline
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...
GLPI10.0.10 (ubuntu 22.04 PHP8.1 Mariadb10.6 ) plugins : comportements 2.7.2 reports 1.16.0 formcreator 2.13.8, datainjection 2.13.4 fields 1.21.6
Offline
Thanks, third dump succeded.
Offline
Pages: 1