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 2018-07-14 19:37:04

loyolajavi
Member
Registered: 2017-11-10
Posts: 8

Migrate from MyIsam to InnoDB - Right steps

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

#2 2018-07-14 21:10:17

loyolajavi
Member
Registered: 2017-11-10
Posts: 8

Re: Migrate from MyIsam to InnoDB - Right steps

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

Board footer

Powered by FluxBB