adjusting innodb_log_file_size in mysql to get around
I was getting “ERROR 1033 (HY000): Incorrect information in file: ‘./realworx_production/analyzers.frm’” whenever I tried to adjust my mysql innodb parameters and run a query. To adjust this you have do delete or move the ib_logfile0 and ib_logfile1 file in your datadir. Then start the database. So step-by-step
- stop mysql
- modify my.cnf, specifically the changes you want to make to innodb_log_file_size
- move or delete ib_logfile1 and ib_logfile0
- start database.
Written on May 11, 2010