How to convert database from innodb to InnoDB in phpMyAdmin?

In phpMyAdmin, click the "SQL" tab and paste the following in there--changing your_database to the actual database you want to change.

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

Or if that doesn't work, do the following under SSH (change your_database to your actual database name)

mysqldump --add-drop-table your_database > your_database.sql
sed -i.bak 's/MyISAM/InnoDB/g' your_database.sql

Go into phpMyAdmin and drop all tables from the database you are converting--sometimes --add-drop-tables doesn't work. After go back to SSH and do the following:

mysql your_database < your_database.sql
Tags: mysql Server admin