Mysqld crashes when I try to dump everything at once. I made a test by extracting
information from only one table, and it worked. I will try yet with another tables. But I
guess that is it... Thanks a lot, people. You were great. =)
De: Johan De Meersman [mailto:vegivamp@stripped]
Enviada em: quinta-feira, 26 de janeiro de 2012 14:53
Para: Todd Lyons
Cc: MySQL Help; Suporte Avanutri
Assunto: Re: RES: RES: Force drop table
----- Original Message -----
> From: "Todd Lyons" <tlyons@stripped>
> 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