NYCPHP Meetup

[Matt Juszczak]

Don't remove the logfiles. Back them up. Depending on the innodb_flush_trx_on_commit variable setting, that could be bad to remove them. 

As for the frm files, are these innodb or myisam tables?  It sounds like myisam. Run myisamchk from the command line on all myisam tables. Make sure the server is shutdown. 

Matt 

------Original Message------
From: Rob Marscher
Sender: talk-bounces at lists.nyphp.org
To: NYPHP Talk
ReplyTo: NYPHP Talk
Subject: Re: [nycphp-talk] Help Recovering from a Server Crash
Sent: Jul 7, 2010 10:05

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 ;)

_______________________________________________
New York PHP Users Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk

http://www.nyphp.org/Show-Participation