设为首页 加入收藏

TOP

MySQL数据库下.frm .MYD .MYI损坏恢复操作(二)
2014-11-24 08:11:58 来源: 作者: 【 】 浏览:2
Tags:MySQL 数据库 .frm .MYD .MYI 损坏 恢复 操作
-update-state Mark tables as crashed if you find any errors
-T, --read-only Dont mark table as checked

Repair options (When using -r or -o)
-B, --backup Make a backup of the .MYD file as filename-time.BAK
--correct-checksum Correct checksum information for table.
-D, --data-file-length=# Max length of data file (when recreating data
file when its full)
-e, --extend-check Try to recover every possible row from the data file
Normally this will also find a lot of garbage rows;
Dont use this option if you are not totally desperate.
-f, --force Overwrite old temporary files.
-k, --keys-used=# Tell MyISAM to update only some specific keys. # is a
bit mask of which keys to use. This can be used to
get faster inserts!
-r, --recover Can fix almost anything except unique keys that arent
unique.
-n, --sort-recover Forces recovering with sorting even if the temporary

首页 上一页 1 2 下一页 尾页 2/2/2
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇五个影响mysql性能的关键配置 下一篇MySQL字符型数据区分大小写

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容:

·MySQL 基础入门视频 (2025-12-26 23:20:22)
·小白入门:MySQL超详 (2025-12-26 23:20:19)
·关于 MySQL 数据库学 (2025-12-26 23:20:16)
·SOLVED: Ubuntu 24.0 (2025-12-26 22:51:53)
·Linux 常用命令最全 (2025-12-26 22:51:50)