Easily Convert Database from InnoDB to MyISAM

Loading

Have you every wonder how to convert InnoDB database to MyISAM database in your phpMyAdmin? Supedium has come out with a very easy solution to your issue.

First of All go to your phpMyAdmin that can be easily found in your cPanel.

Then, when you are in phpMyAdmin area find the “SQL” tab and click on it.

After that, search for your write down the database name that you want to change the database storage system from InnoDB to MyISAM.

Moreover, write down the command as “ALTER TABLE your database name here ENGINE=myisam;”

Example:

ALTER TABLE wp_links ENGINE=myisam;
ALTER TABLE wp_options ENGINE=myisam;
ALTER TABLE wp_postmeta ENGINE=myisam;

Then, click on Go button located below.

You’re done all the database will be changed from InnoDB to MyISAM. It’s that easy😃!

Still Wondering How can you Easily change database from MyISAM to InnoDB?

It is the same step as shown above but you just need to change the command to “ALTER TABLE your database name here ENGINE=INNODB;”

See also  Hide "Search for {phrase} on Google" For Google CSE Result

Example:

ALTER TABLE wp_links ENGINE=INNODB;
ALTER TABLE wp_options ENGINE=INNODB;
ALTER TABLE wp_postmeta ENGINE=INNODB;

That’s all you’re done 😄

Do you find our content useful give it a like and share with your WordPress friends now and Supedium appreciate it.

Comments below if you found out any easier way to change the database storage system.

Share This
0Shares

0
  • Be the first to comment

Back to top of page

Register / Login

Message from SUPEDIUM®


Welcome to SUPEDIUM®, to ensure you have seamless experience when browsing our website, we encourage all users to register or login. It only takes less than 2 minutes to register an account :)

Register / Login with Email

Register / Login with Google

This will close in 30 seconds

Sign in

rotate_right

Send Message

image

My favorites

image