MilesWeb Hosting Forum

Please login or register.

Login with username, password and session length



SMF - Just Installed!

Author Topic: How to change the database engine of a MySQL database table?  (Read 3526 times)

0 Members and 1 Guest are viewing this topic.

Offline Dipak Bhoi

  • MilesWeb Team Member
  • Full Member
  • ***
  • Posts: 208
  • Karma: +5/-0
    • View Profile
    • MilesWeb Internet Services
Hello guys,

In this post I will help you how to change the database engine of a MySQL table.

Suppose that you have a database table called your_table currently using MyISAM engine and you wish to change the engine from MyISAM to InnoDB via SSH. Below are the steps.

1. Get the access of your server with root user via SSH.
2. Login to the MySQL server from the command line with the following command:

#mysql -u root -p

You will get the " mysql> " prompt, the MySQL query that will be used is:

Select the database.
mysql> use your_database_name;

Run below query.
mysql>ALTER TABLE your_table ENGINE = InnoDB;
mysql> exit

Hey you have done !!

Enjoy !!!
cPanel Hosting in India - cPanel Hosting in India.

Grab an SSL for your website and SAVE 20% now. Coupon Code SSLSAVE20.

MilesWeb Hosting Forum