• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

MySQL storage engines!

C

concreteDonkey

Member
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. 😛
 
probably not (someone else please confirm), you may see a small performance hit.... going the other way (inno -> isam) would be a bad idea....
 
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 🙂
 
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top