MySQL storage engines!

[concreteDonkey]

I want to change my whole database(about 10 tables) form MyISAM to InnoDB, is anything bad gonna happen?

Just a yes or no will do if you're a bit lazy.

 

[statik213]

probably not (someone else please confirm), you may see a small performance hit.... going the other way (inno -> isam) would be a bad idea....

 

[concreteDonkey]

cheers statik213!

Thanks for the reply, but I am aware of the performance hit.

I didn't really mean something like a performance hit though. I meant, like will I unexpectedly lose any data. Or has anyone ever changed a whole database's storage engine and had any weird things happen to the structure/data?

Sorry, I realise I didn't explain myself very well.

Thanks again for the reply

 

[statik213]

I doubt you would have any problems... I haven't tried this though.
Make sure you have a backup of your exisiting DB before making this change.

 

[HDTVMan]

I havent dont that directly but if you read from one table while populating another its no big deal.