SQLyog?

[saidbakr]

What's this?
When I create a new table and set its type as InnoDB, then I come back to check its type, I find it as MyISAM type. This means SQLyog cannot create InnoDB table Type?!!
I use Version 3.0 of SQLyog and Version 3.23.54 of MySQL on WinME
So Please any one can Help me? 😕

[jerdo]

On ver 3.xx, the regular MySQL executable/daemon can't handle InnoDB, you have to run the max version. You will also have to make some changes to you my.ini/cnf file for InnoDB to work. Check out the MySQL site for instructions on how to do this.

[saidbakr]

I already have checked MySQL manual about InnoDB table type, but the way which they told to modify my.ini to start InnoDB seems to be complicated I can not understand exactly what I have to write in my.ini, So If you can tell me this, in the mannar of 1,2,3,4,... steps order, I will thank for you.