Community Documentation

v3 Knowledgebase

How to change the database storage engine

In order to change the storage engine from MyISAM to INNODB just run the following these steps:

1) To backup the database following this tutorial:

2) To put your site offline by going to AdminCP -> Extension -> Setting -> System Setting ->
Site is offline? = TRUE
Blank Template = TRUE

3) Download the following file:

4) Place the file database_engine.php in the website directory.

5) To run the script at

6) Once the scrips has finished you will get the message:
"Storage engine has changed to INNODB"

7) Just check the storage engine using phpmyadmin and it needs to be as this screen-shot: