Tony Stark Tony Stark - 1 year ago 84
SQL Question

MySql - Convert InnoDB to MyISAM Storage Engine of Database

How to convert database storage engine from

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.