In this guide we will explain how to convert from MyISAM to InnoDB in just 5 simple steps! We will use phpMyAdmin as that is the most easy way without any hassle.

PhpMyAdmin_logophpMyAdmin

1. Log in to your phpmyadmin

The address is usually, http(s)://www.example.com/phpmyadmin

2. change one of the db rows

In this example I will change “orderrader” to InnoDB.

1

 

3. Simply go to “Operations”

2

 

4. Change this value to InnoDB

3

 

5. And you’re done. Simple as that!

4

 

Option 2: Change whole database at once

Run this SQL query in phpMyAdmin:

SET @DATABASE_NAME = 'name_of_your_db';

SELECT  CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = @DATABASE_NAME
AND     `ENGINE` = 'MyISAM'
AND     `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;

And then copy the output and run a new SQL query with that output.



PRO TIP

Install ownCloud and host your own private cloud. Download  the pre-configured ownCloud VM today!