GLPI 9.3 convert tables to innodb

Presentation

Since version 9.3 of GLPI, the new installations use the InnoDB storage format instead of MyISAM. When updating your GLPI, the tables will not be automatically migrated. The migration must be done by hand. When connecting to your site you will have an alert message telling you that tables are not in the correct storage format
Message alerte après mise à jour

Convert tables to INNODB format

The developers of GLPI have created a script that allows you to do the migration, it is in REPERTOIRE_GLPI / scripts / innodb_migration.php With a small database, it is possible to launch the script directly from a browser. I strongly advise against this solution which can damage your database. To migrate the database we will use GLPI in CLI mode, ie execute the script directly from a command prompt for Windows or from a console on Linux.

GLPI migration INNODB on Windows

1. Open your Windows Explorer and go to the installation location of GLPI 1 and identify script 2.
Emplacement du script de migration innodb

Tip: select the script, hold down the Shift key and right click on it and click Copy As Path.

2. Open a notepad (Notepad ++) and paste.

3. Do the same with the PHP executable found in C: \ Program Files (x86) \ PHP \ vX.X \ php.exe

4. Copy the path before the script location in the notepad. You should have something that looks like the catch below.

Ligne de commande à passer

5. Open a command prompt in Administrator and copy the line of the notepad and press Enter to start the command.

"C:\Program Files (x86)\PHP\v7.2\php.exe" "D: \www\glpi\scripts\innodb_migration.php"

Invite de commande GLPI migration INNODB

7. Wait while migrating tables.
Migration ...

8. When finished, close the window.
Migration innodb terminée

9. Return to GLPI and refresh the page, the message should be gone.

It is possible that the message is displayed again after the installation of plugin whose creation of tables is declared in MyISAM.

GLPI migration INNODB on Linux

1. Log in SSH to the web server.

2. Enter the following command (to be adapted according to your environment) :

php /var/www/glpi/scripts/innodb_migration.php

 


How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!



Related Posts


How to update GLPI
In this tutorial I will explain how to update GLPI. Before updating GLPI, I strongly recommend that you make a full backup (file + database). Once your backup is done, you should also check the following: If you use plugins, that they are compatible

WSUS: automatic approval of updates
Introduction In this tutorial, we will see how to automatically approve definition updates on WSUS. Definition updates are available almost daily, automatic approval avoids doing so. Approve updates automatically 1. Go to the WSUS console in Options

SQL Express: backup plan
Introduction With the SQL Express version, it is not possible to set up a backup plan using SSMS. There are many scripts on the Internet for performing a backup, in this tutorial I will explain how to put in backup plan with a SQL Backup Master that

2 thoughts on “GLPI 9.3 convert tables to innodb”

  1. Olá, tive esse problema para converte tabelas para innodb.
    Estou usando o Xampp, segui os passos que do seu TUTO, mais o meu PHP está rodando no Xampp, não tenho a pasta C: \ Arquivos de Programas (x86) \ PHP \ vX.X \ php.exe.

    Você sabe como realizar esse procedimento só pelo Xampp?

    • Olá,
      Para o Xampp, o princípio é o mesmo, vá para o diretório de instalação do Xampp e leia a pasta onde o PHP está instalado. Substitua o caminho do tutorial pelo da sua instalação.

Leave a Comment