Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
    
Maybe it's not so much about PHPMyAdmin but MySQL directly. Have you tried this: - stackoverflow.com/questions/2286813/… –  Sebastian Roth Jan 4 '11 at 4:01
    
It is possible by doing these steps: navigate to > phpmyadmin -> more -> variables -> storage engine and change it MyISAM to InnoDB. –  user21380 Mar 16 '13 at 20:33

1 Answer 1

up vote 9 down vote accepted

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.