I use InnoDB almost exclusively in my applications. However, if I'm not careful when setting up the table, I forget to change it and phpmyadmin sticks me with MyISAM. Is there a way to change the default storage engine?
Mysql – How to change the default storage engine in phptheadmin
innodbmyisamMySQLphpmyadmin
Related Question
- Mysql – Which MySQL storage engine is the most similar to ARCHIVE when that is not available
- Mysql – Unable to change engine to MyISAM in MySQL
- Mysql – Change Storage Engine on Referenced Tables
- Mysql – If all tables are theisam, should I use theisam engine instead of default innodb
- MySQL – Storage Engine Changed from InnoDB to MyISAM on Restoring Backup
- MySQL – change all tables’ ENGINE from MyISAM to InnoDB with a single query
- Mysql – Changing storage engine to InnoDb from MyIsam is dropping records from table
Best Answer
You have to add the line
default-storage-engine = InnoDB
under the[mysqld]
section of your mysql config file (my.cnf or my.ini depending on your operation system) and restart the mysqld service.I don't believe you can change this through PhpMyAdmin.