Re: How do I convert an InnoDB database into MyISAM?
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.
Subject
Views
Written By
Posted
77359
May 16, 2005 10:45AM
34216
May 17, 2005 02:33AM
40782
October 14, 2005 08:46AM
15542
May 17, 2005 11:15AM
13765
May 18, 2005 02:08AM
13663
September 21, 2005 03:04PM
11034
December 27, 2007 07:42PM
9990
December 28, 2007 07:28PM
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.