Tony Stark Tony Stark - 2 years ago 134
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 Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download