Link to home
Start Free TrialLog in
Avatar of jayrod
jayrodFlag for United States of America

asked on

Can't change Mrg_MyIsam Tables

I'm using sqlYog to do db dev on a windows system. and it seems that all my tables are Mrg_MyIsam and I can't change them to Innodb. not even with the alter table command. When I export the database to file it says it's creating all the tables with the engine=Innodb setting but I'm just not seeing that.

Any reason why?
ASKER CERTIFIED SOLUTION
Avatar of Umesh
Umesh
Flag of India image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jayrod
jayrod
Flag of United States of America image

ASKER

nope.. i've tried all of that. sorry if I didn't mention that. I drop all the tables in my database and recreated the database and all tables had the innodb option. yet they're still not innodb
SOLUTION
Avatar of lokus
lokus
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jayrod
jayrod
Flag of United States of America image

ASKER

language      CREATE TABLE `language` (\
  `languageId` int(11) NOT NULL auto_increment,\
  `shortCode` varchar(5) NOT NULL default '',\
  `languageName` varchar(50) NOT NULL default '',\
  PRIMARY KEY  (`languageId`),\
  UNIQUE KEY `shortCode` (`shortCode`),\
  UNIQUE KEY `languageName` (`languageName`)\
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC      

It says it's innodb.. so maybe my sqlyog tool is to blame?