snippetsqlMajor
How can I change the default storage engine in phpmyadmin?
Viewed 0 times
enginecanthestoragephpmyadmindefaulthowchange
Problem
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?
Solution
You have to add the line
I don't believe you can change this through PhpMyAdmin.
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.
Context
StackExchange Database Administrators Q#96, answer score: 25
Revisions (0)
No revisions yet.