----- Original Message -----
From: "Rafal Kedziorski" <[EMAIL PROTECTED]>
To: "Scott Purcell" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com>
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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
