change storage engine

Hello all,

I need to change the storage engine of an existing table from MyIsam to
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?

Thanks for your help

Nick

Gordon Burditt wrote:
>> I need to change the storage engine of an existing table from MyIsam
>> to 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?
>
> ALTER TABLE foo ENGINE=InnoDB;
>
> This works for MySQL 5. I believe some earlier versions used
> Type= instead of ENGINE= .

Yup, ALTER TABLE `table_name` TYPE = innodb
--
Rik Wasmus

thanks all

"Rik" <luiheidsgoeroe@hotmail.com> schreef in bericht
news:e3tsg7$sci$1@netlx020.civ.utwente.nl...
> Gordon Burditt wrote:
>>> I need to change the storage engine of an existing table from MyIsam
>>> to 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?
>>
>> ALTER TABLE foo ENGINE=InnoDB;
>>
>> This works for MySQL 5. I believe some earlier versions used
>> Type= instead of ENGINE= .
>
> Yup, ALTER TABLE `table_name` TYPE = innodb
> --
> Rik Wasmus
>
>