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

  1. stop mysql
  2. modify my.cnf, specifically the changes you want to make to innodb_log_file_size
  3. move or delete ib_logfile1 and ib_logfile0
  4. start database.
Written on May 11, 2010