问题背景:
服务器被攻击,数据库A被删!
目前进展:
1.用恢复软件把数据库A中的frm、Myd、MyI文件进行还原,但访问数据库时,则提示Incorrect information in file
2.浏览数据库时发现有几张表提示使用中,从而不能正常访问与操作表
问题:
如何在保证不丢失数据的前提下,可以正常访问数据库
自己尝试过的办法:
1.使用repire table ,这时就可以操作表了,可是数据全没了!
2.其中myd与myi文件的大小均大于0,推测不是索引损坏而导致的问题
A very important database has gone corrupt that was sitting on server at a shared web host, and I didn't back up. The table contains a large list of very important email addresses. I can get a table listing, but if I open any of the tables with Navicat or phpMyAdmin, I get the following error:
Incorrect information in file: './the-table-name.frm'
I was able to get a hold of the .frm files associated with the database from the web host.
There is other data in there, but if I could at least