Re: InnoDB to MyISAM

[Martijn Tonies]

> > 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