MySQL Error: 1033 Incorrect information in file “./xx/info.frm”

[vcxzv]

如题 1033 Incorrect information in file “./xx/info.frm”
我电脑昨天下午突然弹出好多次 windows -延缓写入失败，.......请转存xxxx的提示，然后就卡死不动，好不容易关机后重开机，发现mysql 不能启动，出现1067 xxx意外终止的错误，在网上找了下修改my.ini后能启动，但是当想打开表后就出现如题所示的错误，网上找了好多方法，说什么删除log什么的，但是还是不能打开表，想打开数据库里面全部表都会弹出如题的错误，谁知道怎么修改好？

[WWWWA]

确定表的引擎是什么
MYISAM：
mysqlcheck.exe -r test -uroot -p
INNODB:
把日志文件ib_logfile删掉再启动mysql（请注意备份）。

注：删log之前确保innodb_fast_shutdown的值不是2，如果是2则需要先改为1，然后重启使之生效，再关闭mysql删log文件。其默认值是1。

[vcxzv]

[Quote=引用 1 楼 的回复:]

确定表的引擎是什么
MYISAM：
mysqlcheck.exe -r test -uroot -p
INNODB:
把日志文件ib_logfile删掉再启动mysql（请注意备份）。

注：删log之前确保innodb_fast_shutdown的值不是2，如果是2则需要先改为1，然后重启使之生效，再关闭mysql删log文件。其默认值是1。
[/Quote]
innodb 这个设置过了 还是不行啊

[WWWWA]

错误日志中的内容是什么

[vcxzv]

[Quote=引用 3 楼 的回复:]

错误日志中的内容是什么
[/Quote]
我改了innodb 这个设置 还是提示如题所示

[vcxzv]

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120529 15:03:05 InnoDB: Error: unable to create temporary file; errno: 22
120529 15:03:05 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
120529 15:03:13 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_gift_code.frm'
120529 15:03:13 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_gift_code.frm'
120529 15:03:18 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

120529 15:03:20 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2 user: 'root'

120529 15:03:20 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120529 15:10:28 InnoDB: Error: unable to create temporary file; errno: 22
120529 15:10:28 [ERROR] Default storage engine (InnoDB) is not available
120529 15:10:28 [ERROR] Aborting

120529 15:10:28 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120529 15:10:33 InnoDB: Error: unable to create temporary file; errno: 22
120529 15:10:33 [ERROR] Default storage engine (InnoDB) is not available
120529 15:10:33 [ERROR] Aborting

120529 15:10:33 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120529 15:10:41 InnoDB: Error: unable to create temporary file; errno: 22
120529 15:10:41 [ERROR] Default storage engine (InnoDB) is not available
120529 15:10:41 [ERROR] Aborting

120529 15:10:41 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120529 15:11:19 InnoDB: Error: unable to create temporary file; errno: 22
120529 15:11:19 [ERROR] Default storage engine (InnoDB) is not available
120529 15:11:19 [ERROR] Aborting

120529 15:11:19 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120529 15:11:23 InnoDB: Error: unable to create temporary file; errno: 22
120529 15:11:23 [ERROR] Default storage engine (InnoDB) is not available
120529 15:11:23 [ERROR] Aborting

120529 15:11:23 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120529 15:12:16 InnoDB: Error: unable to create temporary file; errno: 22
120529 15:12:16 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
120529 15:12:39 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_code.frm'
120529 15:12:39 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_code.frm'
120529 15:14:02 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

120529 15:14:04 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2 user: 'root'

120529 15:14:04 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 1 user: 'root'

120529 15:14:04 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120529 15:20:11 InnoDB: Error: unable to create temporary file; errno: 22
120529 15:20:11 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
120529 15:21:11 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_gift_code.frm'
120529 15:21:11 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_gift_code.frm'
120529 15:29:53 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

120529 15:29:53 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120529 16:43:46 InnoDB: Error: unable to create temporary file; errno: 22
120529 16:43:46 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
120529 16:43:59 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_code.frm'
120529 16:43:59 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_code.frm'
120529 16:45:05 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_gift_code.frm'
120529 16:45:05 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_gift_code.frm'
120529 17:13:16 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

120529 17:13:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8 user: 'admin'

120529 17:13:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 2 user: 'root'

120529 17:13:18 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 1 user: 'root'

120529 17:13:18 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120529 17:18:28 InnoDB: Error: unable to create temporary file; errno: 22
120529 17:18:28 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
120529 17:53:29 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

120529 17:53:31 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 1 user: 'admin'

120529 17:53:31 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120529 17:57:03 InnoDB: Error: unable to create temporary file; errno: 22
120529 17:57:03 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
120529 18:00:11 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\tree_treehole.frm'
120529 18:00:11 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\tree_treehole.frm'
120529 18:14:31 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\tree_treehole.frm'
120529 18:14:31 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\tree_treehole.frm'
120529 18:39:56 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

120529 18:39:56 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120530 8:36:47 InnoDB: Error: unable to create temporary file; errno: 22
120530 8:36:47 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
120530 8:38:05 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_code.frm'
120530 8:38:05 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_code.frm'
120530 8:38:57 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_gift_code.frm'
120530 8:38:57 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_gift_code.frm'
120530 9:39:12 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\tree_treehole.frm'
120530 9:39:12 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\tree_treehole.frm'
120530 9:57:58 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_single_code.frm'
120530 9:57:58 [ERROR] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Incorrect information in file: '.\zypc\author_single_code.frm'

[vcxzv]

这个是最主要的吧 应该

120528 9:06:01 InnoDB: Started; log sequence number 0 183820067
120528 9:06:01 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.37-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120528 14:38:27 InnoDB: Error: unable to create temporary file; errno: 22
120528 14:38:27 [ERROR] Default storage engine (InnoDB) is not available
120528 14:38:27 [ERROR] Aborting

120528 14:38:27 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120528 14:42:57 InnoDB: Error: unable to create temporary file; errno: 22
120528 14:42:57 [ERROR] Default storage engine (InnoDB) is not available
120528 14:42:57 [ERROR] Aborting

120528 14:42:58 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120528 15:16:12 InnoDB: Error: unable to create temporary file; errno: 22
120528 15:16:12 [ERROR] Default storage engine (InnoDB) is not available
120528 15:16:12 [ERROR] Aborting

120528 15:16:12 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120528 15:55:08 InnoDB: Error: unable to create temporary file; errno: 22
120528 15:55:08 [ERROR] Default storage engine (InnoDB) is not available
120528 15:55:08 [ERROR] Aborting

120528 15:55:08 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120528 15:55:30 InnoDB: Error: unable to create temporary file; errno: 22
120528 15:55:30 [ERROR] Default storage engine (InnoDB) is not available
120528 15:55:30 [ERROR] Aborting

120528 15:55:30 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120528 15:55:52 InnoDB: Error: unable to create temporary file; errno: 22
120528 15:55:52 [ERROR] Default storage engine (InnoDB) is not available
120528 15:55:52 [ERROR] Aborting

120528 15:55:52 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Can't create/write to file 'C:\WINDOWS\TEMP\ib2' (Errcode: 22)
120528 15:56:23 InnoDB: Error: unable to create temporary file; errno: 22
120528 15:56:23 [ERROR] Default storage engine (InnoDB) is not available
120528 15:56:23 [ERROR] Aborting