XF 2.1 Convert MyISAM to InnoDB

[ASap]

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:

XF 2.1 - Database Crash xf_post.myi

Hi there, One of our forum databases has crashed 🤕 Output when I do mysqlcheck: db.xf_post warning : Table is marked as crashed and last repair failed warning : Size of indexfile is: 327299072 Should be: 1024 error : Found key at page -1 that points to record outside datafile error...

xenforo.com

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]

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:

XF 2.1 - Database Crash xf_post.myi

Hi there, One of our forum databases has crashed 🤕 Output when I do mysqlcheck: db.xf_post warning : Table is marked as crashed and last repair failed warning : Size of indexfile is: 327299072 Should be: 1024 error : Found key at page -1 that points to record outside datafile error...

xenforo.com

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....

 

[AndyB]

In the XenForo manual it explains what to do:

https://xenforo.com/docs/xf2/unicode/

Follow the instruction for Running the conversion script.

 

[Nicolas FR]

I hope he had found the solution since March 2020.

 

[Masetrix]

Anyone know how can I upgrade the storage engine from MyISAM to InnoDB?

Was the question...

In the XenForo manual it explains what to do:

For real?

I hope he had found the solution since March 2020.

That's right, but now others who are looking for the same thing can get an answer.