NYCPHP Meetup

[Rob Marscher]

On Jul 7, 2010, at 8:43 AM, Randal Rust wrote:
> 1. Some of them are listed as 'in use.' When I try to view the
> structure of the table, I get the following error message:
> 
> #1033 - Incorrect information in file: './ahc_db/cd_news_categories.frm'

Yeah, this is bad news.  Could mean that the data is corrupted... but I've also seen this happen when simply the log files weren't what innodb was expecting.  Try to grab the my.cnf file the bad server was using so you can use the same settings on your new server.   Also, try removing the ib_logfile* files and restarting the server.

If you google that error - "incorrect information in file" - you'll get several other suggestions.  Good luck.

And setup nightly backups this time ;)