Knowledgebase
Webinova Online Customer Support > Webinova Help Desk > Knowledgebase

Search help:


How to change the database engine of a MySQL database table?

Solution

In this article we will show you how to change the database engine of a MySQL table.

Let’s assume that you have a database table called my_table using MyISAM engine and you wish to change the engine from MyISAM to InnoDB.

The MySQL query that should be used is:

ALTER TABLE my_table ENGINE = InnoDB;

The easiest way to make this change is through phpMyAdmin:

Open your phpMyAdmin tool and select the database which contains my_table. Then click the SQL tab, paste the above query there and click the Go button.

If the query is executed properly, the database engine of the table will be changed to InnoDB.

 
Was this article helpful? yes / no
Article details
Article ID: 195
Category: cPanel MySQL Databases
Date added: 2012-12-07 13:06:29
Views: 23
Rating (Votes): Article rated 3.0/5.0 (6)

 
« Go back

 
Powered by Help Desk Software HESK - brought to you by Help Desk Software SysAid