1、可能是由于误删除,导致MYSQL数据丢失;
2、phpMyAdmin查看,提示数据记录为0,但文件大小还在,基本和原来差不多;
3、查看.MYD文件,内容还在,能看到相关内容;
4、MYISAMCHK检查提示:
Checking MyISAM file: D:\AMP\MySQL\db_gfx_gov_r\ecms_content_info
Data records: 0 Deleted blocks: 4218
myisamchk: warning: 1 client is using or hasn't closed the table properly
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check data record references index: 5
- check record links
MyISAM-table 'D:\AMP\MySQL\db_gfx_gov_r\ecms_content_info' is usable but should
be fixed这种情况,能否恢复?谢谢。
2、phpMyAdmin查看,提示数据记录为0,但文件大小还在,基本和原来差不多;
3、查看.MYD文件,内容还在,能看到相关内容;
4、MYISAMCHK检查提示:
Checking MyISAM file: D:\AMP\MySQL\db_gfx_gov_r\ecms_content_info
Data records: 0 Deleted blocks: 4218
myisamchk: warning: 1 client is using or hasn't closed the table properly
- check file-size
- check record delete-chain
- check key delete-chain
- check index reference
- check data record references index: 1
- check data record references index: 2
- check data record references index: 3
- check data record references index: 4
- check data record references index: 5
- check record links
MyISAM-table 'D:\AMP\MySQL\db_gfx_gov_r\ecms_content_info' is usable but should
be fixed这种情况,能否恢复?谢谢。
原来没有数据备份,logbin也没开。
并且MYD打开,能看到相关内容。
是指用什么工具?我用MYISAMCHK -safe-recover 恢复不行。