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:


  • Riley
    started a topic How to change default storage engine in phpmyadmin?

    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