Tony Stark Tony Stark - 7 months ago 28
SQL Question

MySql - Convert InnoDB to MyISAM Storage Engine of Database

How to convert database storage engine from

InnoDB
to
MyISAM
on
MySQL
?
I found so many sites which convert the storage engine of database table, but not for database.
i attached screen shot for better understand

Thanks in advance.

Answer

You can't change the default storage engine for a database, but you can change it for the whole server using the default-storage-engine config setting. Note that this will not actually change the storage engine for existing tables though, just for new ones created after the change.

Comments