Announcement

Collapse
No announcement yet.

How to change default storage engine in phpmyadmin?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to change default storage engine in phpmyadmin?

    Hi,
    Iím using InnoDB completely in my applications. Though, if I'm careless while setting up the table, I forget to change it and phpmyadmin sticks me with MyISAM.
    Can anyone know that how to change the default storage engine?

  • #2
    Hello,

    You need to add the line default-storage-engine = InnoDB below the [mysqld] section of your mysql config file (my.cnf or my.ini depending on your operation system) and restart the mysqld service.

    Comment

    Working...
    X