Re: InnoDB to MyISAM

[Jeremiah Gowdy]

----- Original Message ----- 
From: "Rafal Kedziorski" <rafcio@stripped>
To: "Scott Purcell" <spurcell@stripped>; <mysql@stripped>
Sent: Wednesday, May 25, 2005 6:06 AM
Subject: Re: InnoDB to MyISAM


> http://dev.mysql.com/doc/mysql/en/converting-tables-to-innodb.html

He's converting InnoDB to MyISAM.

I would recommend something like this:

CREATE TABLE newtable LIKE oldtable;

ALTER TABLE newtable ENGINE=MyISAM;

ALTER TABLE newtable DISABLE KEYS;

INSERT INTO newtable SELECT * FROM oldtable;

ALTER TABLE newtable ENABLE KEYS;

>>key relationships?
> 
> MyISAM can't FK's.

Yes it can, they're just not enforced.