----- Original Message ----- > From: "Todd Lyons" <tly...@ivenue.com> > > It doesn't matter what you set in innodb_force_recovery. If you do > not have the obras.frm file (which contains the schema definition of > the table), I don't know if you can retrieve the info. Put that file
I recommended he delete that file since he was trying to delete the table anyway, and the log said there was no metadata for that table. Mateus, I see in the last bit of logs that the recovery sequence number remains constant. Does the server still crash at that point even though there are no more error messages? What happens if you remove the innodb_force_recovery setting? If it keeps crashing without errors, you may be up shit creek :-) You can try running it through strace, but the output of that is going to be long and confusing. If you can't just do a clean install and restore from backups, a good consultant might be your best bet at this point. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
