Announcement

Collapse
No announcement yet.

How to change default storage engine in phpmyadmin?

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

  • Nimbus
    replied
    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.

    Leave a comment:


  • 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?
Working...
X