Store
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:
* http://www.phpfox.com/kb/article/93/backup-database/

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:
* https://www.dropbox.com/s/k6yyvlbl2r4nmeg/database_engine.php

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

5) To run the script at http://yoursite.com/database_engine.php

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:
* https://www.dropbox.com/s/x773b9uvjtomddj/storage%20engine%20tutorial.png