XF 2.1 Convert MyISAM to InnoDB

ASap

Active member
Hi there,

I have old XF installation (since XF beta), and now it's running on XF 2.1

Just realised when my xf_post table crashed recently:
The XF version upgrades didn't upgrade the MySQL storage engine from MyISAM to InnoDB.

Anyone know how can I upgrade the storage engine from MyISAM to InnoDB?
Is there any official guide of doing this?
 

Masetrix

Well-known member
Hi there,

I have old XF installation (since XF beta), and now it's running on XF 2.1

Just realised when my xf_post table crashed recently:
The XF version upgrades didn't upgrade the MySQL storage engine from MyISAM to InnoDB.

Anyone know how can I upgrade the storage engine from MyISAM to InnoDB?
Is there any official guide of doing this?
In phpMyAdmin -> yourDataBase -> Console add:

alter table xf_your_table_name ENGINE=innodb;

Hit ctrl+enter....
 
Last edited:
Top