MySQL Forums
Forum List  »  MyISAM

Re: How do I convert an InnoDB database into MyISAM?
Posted by: Cagdas Ucar
Date: January 08, 2008 12:23PM

This is the easiest way I found:

1- Execute the following SQL

select concat('alter table ',table_schema,'.',table_name,' engine=MyISAM;')
from information_schema.tables
where engine = 'InnoDB'

2- Execute the result set as SQL script (if you are using MySQL query browser, you will need to remove the quotes put around the rows with empty characters and remove them before execution)

Hope this helps.

Options: ReplyQuote


Subject
Views
Written By
Posted
40782
October 14, 2005 08:46AM
Re: How do I convert an InnoDB database into MyISAM?
13830
January 08, 2008 12:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.