Storage engine.

Moderator: crythias

Locked
spiderpig
Znuny expert
Posts: 198
Joined: 15 Dec 2011, 02:26
Znuny Version: OTRS 5

Storage engine.

Post by spiderpig »

Hi,
in service center i get this message:

"Table Storage Engine (acl, acl_sync, dynamic_field, dynamic_field_value, gi_debugger_entry, gi_debugger_entry_content, gi_object_lock_state, gi_webservice_config, gi_webservice_config_history, personal_services, pm_activity, pm_activity_dialog, pm_entity_sync, pm_process, pm_transition, pm_transition_action, scheduler_task_list, sessions, smime_signer_cert_relations, support_bench_test, system_data, system_maintenance)
Tables with a different storage engine than the default engine were found"

when i was upgradeing from OTRS 3.0 -> 4.0 i needed to change the storage engine from isam to innodb.

how can i convert these tables to innodb?
wurzel
Znuny guru
Posts: 3273
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: Storage engine.

Post by wurzel »

Hi,

dump database, correct engine, restore.

Or use the InnoDBMyISAM switch script in /opt/otrs/bin

Flo
OTRS 2025 SILVER (Prod)
OTRS 2025 auf Debian 12 (Test)
Znuny 7.x latest version testing auf Debian 12

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
spiderpig
Znuny expert
Posts: 198
Joined: 15 Dec 2011, 02:26
Znuny Version: OTRS 5

Re: Storage engine.

Post by spiderpig »

which method do you recommend?
spiderpig
Znuny expert
Posts: 198
Joined: 15 Dec 2011, 02:26
Znuny Version: OTRS 5

Re: Storage engine.

Post by spiderpig »

i used the otrs.Mysqlinnodbmysam, and it solved the problem.

thank you.
Locked