In order to optimise my MySQL 5.1 (running on Window 2008 WebServer). I changed a few InnoDB options in my.ini namely the innodb_buffer_pool_size and innodb_log_file_size. But now when I am trying to restart the service it won't start. In the event viewer I can see the following errors:
Unknown/unsupported table type: INNODB
I have read about deleting log files and then starting the service but I have no clue where those log files are on windows machine. Also what is the best way to recover from this trauma without loosing any table data ?
show variables like 'innodb_buffer_pool_size';
,show variables like 'innodb_log%';
,show variables like 'innodb_data%';
. Please also show what these variable settings look like in my.ini – RolandoMySQLDBA Feb 2 '12 at 21:36