> > 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.
LOL - that's just like saying that MyISAM supports transactions if you only do transactions that are a single statement... In other words: useles. With regards, Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
