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.
Feel free to comment on the post but keep it clean and on topic.comments powered by Disqus
Software Development for Linux/Unix since 1995. I've done everything from Perl,C/C++,Java,Flash,php, ruby and currently node.js. Always interested in pushing technology one step further than expected.