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

#26 2019-05-10 16:16:36

tiagortrt
Member
Registered: 2019-05-10
Posts: 3

Re: 388 tables not migrated to InnoDB engine.

AlexNL wrote:

Windows
1.Abrir Panel de Control de XAMPP
2.Click Shell
3.Ir a la Ruta de la Carpeta Script, Ejemplo: "Cd C:\xampp\htdocs\scripts" <sin las comillas
4.Teclear: "php innodb_migration.php" <sin las comillas
5. Esperar y Fin

Saludos


These steps solved my problem using Xampp.
Thank you

Offline

#27 2019-06-17 09:55:53

TomaszD
Member
Registered: 2019-06-17
Posts: 1

Re: 388 tables not migrated to InnoDB engine.

(linux instalation)
/usr/bin/php /var/www/html/glpi/scripts/innodb_migration.php

Edit :  this works only for glpi version< 9.4
since 9.4 use console command

Last edited by LaDenrée (2019-06-17 10:54:53)

Offline

#28 2021-06-07 13:24:34

thomaskin
Member
Registered: 2021-06-07
Posts: 1

Re: 388 tables not migrated to InnoDB engine.

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

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
6. Wait while migrating tables.

Migration ...
7. When finished, close the window.

Migration innodb terminée
8. Return to GLPI and refresh the page, the message should be gone.

Offline

Board footer

Powered by FluxBB