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
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.
3. Simply go to “Operations”
4. Change this value to InnoDB
5. And you’re done. Simple as that!
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.
