前天用复制方式备份mysql数据,备份完成后还原时出现 Incorrect information in file: '.\test\stuff.frm',test库中的所有表都这样,不知道用什么方法能把这些文件修好
解决方案 »
- 求助!!!关于MySQL不能启动的问题!!
- 怎么用MYSQL C API往表里插入blob数据?我这样做为什么失败?
- mysql5.1 触发器 label 语句问题?
- 关于jsp页面分页的sql语句问题
- 急问:mysql_real_connect连接出错(bad handshake),请高手帮忙
- win32-mysql 客户端libmysql.dll 开发库支持openssl问题
- !!!!!谁帮我解决我送谁100分!!!!本人在线等着答案!!!!
- 【内存占用】MySQL占用的内存非常高,开始使用SWAP空间
- 一个获取总数的sql,求更优解
- mysql无法插入超链接的问题
- mysqldump 乱码问题
- hibernate mysql 查询出错
test.AGROUP
error : Incorrect information in file: '.\test\agroup.frm'
test.ASYSSET
error : Incorrect information in file: '.\test\asysset.frm'
test.BOOKS
error : Incorrect information in file: '.\test\books.frm'
test.BOOKSNOTE
error : Incorrect information in file: '.\test\booksnote.frm'
test.BOOKSTYPE
error : Incorrect information in file: '.\test\bookstype.frm'
test.CARDLINK
error : Incorrect information in file: '.\test\cardlink.frm'
test.CARDTYPE
error : Incorrect information in file: '.\test\cardtype.frm'
test.CMU_BBS
error : Incorrect information in file: '.\test\cmu_bbs.frm'
test.CMU_FILTER
error : Incorrect information in file: '.\test\cmu_filter.frm'
test.CMU_HONOR
error : Incorrect information in file: '.\test\cmu_honor.frm'
test.CMU_LOG
error : Incorrect information in file: '.\test\cmu_log.frm'
test.CMU_MAIN
error : Incorrect information in file: '.\test\cmu_main.frm'
test.CMU_MEMBER
error : Incorrect information in file: '.\test\cmu_member.frm'
test.CMU_NOTIFY
error : Incorrect information in file: '.\test\cmu_notify.frm'
test.CMU_REPLY
error : Incorrect information in file: '.\test\cmu_reply.frm'
test.CMU_SPACE
error : Incorrect information in file: '.\test\cmu_space.frm'
test.CMU_TOPIC
error : Incorrect information in file: '.\test\cmu_topic.frm'
test.EXAACT
error : Incorrect information in file: '.\test\exaact.frm'
test.EXAACTPUR
error : Incorrect information in file: '.\test\exaactpur.frm'
test.acattrib
error : Incorrect information in file: '.\test\acattrib.frm'
test.acity
error : Incorrect information in file: '.\test\acity.frm'
test.acredit
error : Incorrect information in file: '.\test\acredit.frm'
test.adepart
error : Can't open file: 'adepart.MYD'. (errno: 143)
test.adepartcont
error : Incorrect information in file: '.\test\adepartcont.frm'
test.adepartinfo
error : Incorrect information in file: '.\test\adepartinfo.frm'
test.adeskset
error : Incorrect information in file: '.\test\adeskset.frm'
test.afunlist
error : Incorrect information in file: '.\test\afunlist.frm'
test.alicense
error : Incorrect information in file: '.\test\alicense.frm'
test.alimit
error : Incorrect information in file: '.\test\alimit.frm'
test.anation
error : Incorrect information in file: '.\test\anation.frm'
test.aonline
error : Incorrect information in file: '.\test\aonline.frm'
test.aplacard
error : Incorrect information in file: '.\test\aplacard.frm'
test.aprovin
error : Incorrect information in file: '.\test\aprovin.frm'
test.archives
error : Incorrect information in file: '.\test\archives.frm'
test.archivesnote
error : Incorrect information in file: '.\test\archivesnote.frm'
test.archivestype
error : Incorrect information in file: '.\test\archivestype.frm'
test.asfavori
error : Incorrect information in file: '.\test\asfavori.frm'
test.astuff
error : Incorrect information in file: '.\test\astuff.frm'
test.asyscode
如果是INNODB的表.就完了.
注:删log之前确保innodb_fast_shutdown的值不是2,如果是2则需要先改为1,然后重启使之生效,再关闭mysql删log文件。其默认值是1。