MySQL
How to Change Storage Engine in PhpMyAdmin

How to Change Storage Engine in PhpMyAdmin

By: SolutionsHint    50 views Updated: 05th Feb, 2018
How to Change Storage engine in PhpMyAdmin

The storage engine is used to store the data in a different format so web application uses SQL and MySQL another database to store the data into back-end, but here we are talking about phpmyadmin database for PHP web application which is widely used language, so phpmyadmin have different storage engine:

  1. CSV
  2. InnoDB
  3. Mysam
  4. Aria
  5. Sequence
  6. MRG_MyISAM
  7. Memory

But maybe different according to the update and modification in phpmyadmin, because any software may get updated and can add some additional functionality to the improve the application compatibility. So whenever you want to change storage engine for phpmyadmin, then you can do as following these steps.

Steps to Change Storage engine

  • Just enter into phpmyadmin and select your database
  • After selection of database select the table which you want to change
  • Click on operations on top bar of the window
  • Now select the drop-down list from the Storage Engine  inside table options
  • Select desired selection and Go
  • You have successfully change the storage engine

Anything else let me know!

About the Author

I am a professional blogger from my heart, I am going through all the possible ways that can help to audience. I am trying my best to write content that my readers will like me. I will really be happy when my readers will become more happy with my blog.

Leave a Reply

Your email address will not be published. Required fields are marked *

Tweet
Share6
+1
Share1
0 Shares