>I need to change the storage engine of an existing table from MyIsam toALTER TABLE foo ENGINE=InnoDB;>InnoDB. Can I do this by one alter tabel statement (if yes how?) or is the
>best aproach create a backup, drop the table re-create the table but then
>with the InnoDB type and then insert the backup?
This works for MySQL 5. I believe some earlier versions used
Type= instead of ENGINE= .
Gordon L. Burditt