I'm starting to do some things with my database that will be best done in transactions and I have a question.
all of my major tables are using the myISAM engine currently and I'd like to change them over to INNOdb.
I know that i can use code like so..
Code: Select all
alter table `dbName`.`tblName` ENGINE=INNOdb;My questions are..
Does the database need to be taken down and all connections terminated before I run these commands?
Are there any problems that might/will/should arise after the change? Will INNOdb tables react the same as the myISAM tables to my querys?
Will all of the built in table functions (autoincrement and such) work the same?
Anything else I should be careful of?
Thanks
Will