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 3987 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 - 30-Day Money Back
cPanel Web Hosting - cPanel Hosting in India.
Grab a Free SSL for your website.  WordPress Optimized Solution.

MilesWeb Hosting Forum