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
77397
May 16, 2005 10:45AM
34235
May 17, 2005 02:33AM
40878
October 14, 2005 08:46AM
15558
May 17, 2005 11:15AM
13792
May 18, 2005 02:08AM
13674
September 21, 2005 03:04PM
11047
December 27, 2007 07:42PM
9997
December 28, 2007 07:28PM
Re: How do I convert an InnoDB database into MyISAM?
13841
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.