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
77758
May 16, 2005 10:45AM
34397
May 17, 2005 02:33AM
41666
October 14, 2005 08:46AM
15683
May 17, 2005 11:15AM
13948
May 18, 2005 02:08AM
13802
September 21, 2005 03:04PM
11168
December 27, 2007 07:42PM
10145
December 28, 2007 07:28PM
Re: How do I convert an InnoDB database into MyISAM?
14020
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.