MilesWeb
MilesWeb Hosting Forum

Please login or register.

Login with username, password and session length

 

News:

SMF - Just Installed!


Author Topic: How to change the database engine of a MySQL database table?  (Read 3331 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:

Quote
#mysql -u root -p

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

Select the database.
Quote
mysql> use your_database_name;

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

Hey you have done !!

Enjoy !!!

MilesWeb.com
cPanel Hosting in India - cPanel Hosting in India.

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

MilesWeb Hosting Forum