Database engine of MySQL

[Irene9001]

Hi

I want to change the database engine of MySQL database table. Any suggestion how to do this? I've a database table my_table using MyISAM engine and I want to change the engine from MyISAM to InnoDB.

Thanks

[paullopez]

Hi

You should be used following query:

ALTER TABLE my_table ENGINE = InnoDB;

If you have a cPanel access you should opt the easiest way to make this change from phpMyAdmin

1] Login to Cpanel >> Select phpMyAdmin
2] Select Database (which contains My_Table)
3] Click the SQL tab >> Paste above query >> click the go button.

The database engine of the table be changed to InnoDB, if the query fired properly.

Good Luck