You are not logged in.
Hi everybody,
I've a question with no answers in google (Couldn't find at least):
To migrate glpi db from MyIsam to InnoDB engine (with table glpi_logs < 1GB), this steps will be all right?
A) run the command line tool (scripts/cliupdate.php)
B) run scripts/innodb_migration.php
Best regards
Offline
I found the answer on "Error "345 tables not migrated to InnoDB engine"" topic.
Links in that topic: https://github.com/glpi-project/glpi/issues/4311
http://forum.glpi-project.org/viewtopic.php?id=163667
Answer:
InnodDB migration is not part of the standard update.
After update the glpi, use the provided scripts/innodb_migration.php script or any other tool that would permit this change.
If any table is missing, following the Update to GLPI 9.3 fails [resolved] topic steps:
- restore your dump if exists
- do a mysqlcheck and mysqlrepair to restore the missing table
- if it fails (or if you miss to do a dump), you lost your glpi logs (historical tabs in items), you should recreate the missing table, see this part of install script: https://github.com/glpi-project/glpi/bl … 4257-L4274
- redo migration (prefer cli)
Last edited by loyolajavi (2018-07-14 21:15:18)
Offline