Steps to convert database tables from InnoDB to MyISAM

kumkumsharma

Administrator
Staff member
If you want to convert your database tables to MyISAM then you can follow below steps.But for that it is must to have root access of your database.

You have to first dumped your SQL file via mysqldump and for that we have to replace "ENGINE=INNODB" with "ENGINE=MyISAM".

You can check below example:

Code:
mysqldump user1_db > user1_db.sql
sed -i 's/ENGINE\=InnoDB/ENGINE\=MyISAM/g' ./user1_db.sql
After that you have to drop the database (user1_db) and recreate the database.

At last import the sql dump file.

Code:
mysql user1_db < ./user1_db.sql
 
Top