mysql changing myisam-table to innodb

[crwtrue]

Is there any harm of doing this? How about adding innodb-tables to myisam database?

i did some googleing first: http://rackerhacker.com/2007/10/03/convert-myisam-tables-to-innodb/

according to article converting tables dont seem like a big thing..

[Bjom]

you can mix tables within a DB, no problem. As for simply changing from myisam to innodb: theoretically it should work w/o doing any harm. Practically I would rather create a fresh table and read the data into that, keeping the myisam as a backup for a while until you are absolutely sure, that no data has been lost.

Bjom