MySQL Forums
Forum List  »  Data Recovery

Data Recovery after hardware crash
Posted by: Pavel M
Date: July 13, 2009 03:27AM

Hi,

I had hardware crash on my VDS server (provider fault). It seems provider has restored server backup. After this I've met some problems with MySQL:

#2013 - Lost connection to MySQL server during query

error and #2002 error also when I wanted to make update of medium-large table (near 700 000 of rows). I tried to figure out what is happening and to find solution.

Later I found out that the problems seems to be with one of the DB tables, because CHECK TABLE cause same error on it and mysqldump failed with the same 2013 error on it. Now I'm thinking how to rectreate it and save data.

Signle queries to it work fine, but I think that db file is corrupted somewhere inside.

Do you have any ideas or strategy for my case. Any help would be appreciated. Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Data Recovery after hardware crash
4200
July 13, 2009 03:27AM
2515
September 11, 2009 07:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.