Innodb Handler On Migration?

[fishdan]

I've used the Migration Toolkit to bring SQLServer dbs into mySQL. It's hands down the best too there is.

One thing I've notice though is that I get a warning before I import saying “importing into InnoDB tables may be significantly slower….”

yet when I select the tables for imort, InnoDB is preselected as an option under the “handler” column, and there is no way to select anything else.

I'm only importing the data for a light workout. Speed of load is much more important that DB performance.

Is there someway to make the tables default to MyISAM?

Thanks!

[Author]

Posts