CODEWITHSUNDEEP
mysql
segfault
segfault

Reputation: 5939

How to convert MyISAM to InnoDB

I'm using MySQL 5, and my database experienced some corruption last week. The technicians at my web host managed to save it, but the tables are all converted from the original InnoDB to MyISAM. Currently, some functions in my eCommerce application does not work.

Is there a easy way for me to convert them back to InnoDB again? I can't find anything in phpMyAdmin. Do I need to write a PHP script?

Thanks.

Upvotes: 2

Views: 1783

Answers (2)

Am1rr3zA
Am1rr3zA

Reputation: 7421

If you want do this By Mysql application you can use MySQLQueryBrowser.exe or SQLYoq.exe in both of them you can alter Table and choose DB Engine

Upvotes: 1

akif
akif

Reputation: 12334

You can run this query:

ALTER TABLE table_name ENGINE = InnoDB;

on all tables

Upvotes: 7

Related Questions