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