我电脑昨天下午突然弹出好多次 windows -延缓写入失败,.......请转存xxxx的提示,然后就卡死不动,好不容易关机后重开机,发现mysql 不能启动,出现1067 xxx意外终止的错误,在网上找了下修改my.ini后能启动,但是当想打开表后就出现如题所示的错误,网上找了好多方法,说什么删除log什么的,但是还是不能打开表,想打开数据库里面全部表都会弹出如题的错误,谁知道怎么修改好?
6 个解决方案
#1
确定表的引擎是什么
MYISAM:
mysqlcheck.exe -r test -uroot -p
INNODB:
把日志文件ib_logfile删掉再启动mysql(请注意备份)。
注:删log之前确保innodb_fast_shutdown的值不是2,如果是2则需要先改为1,然后重启使之生效,再关闭mysql删log文件。其默认值是1。
MYISAM:
mysqlcheck.exe -r test -uroot -p
INNODB:
把日志文件ib_logfile删掉再启动mysql(请注意备份)。
注:删log之前确保innodb_fast_shutdown的值不是2,如果是2则需要先改为1,然后重启使之生效,再关闭mysql删log文件。其默认值是1。
#2
innodb 这个设置过了 还是不行啊
#3
错误日志中的内容是什么
#4
我改了innodb 这个设置 还是提示如题所示
#5
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'
#6
这个是最主要的吧 应该
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
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
#1
确定表的引擎是什么
MYISAM:
mysqlcheck.exe -r test -uroot -p
INNODB:
把日志文件ib_logfile删掉再启动mysql(请注意备份)。
注:删log之前确保innodb_fast_shutdown的值不是2,如果是2则需要先改为1,然后重启使之生效,再关闭mysql删log文件。其默认值是1。
MYISAM:
mysqlcheck.exe -r test -uroot -p
INNODB:
把日志文件ib_logfile删掉再启动mysql(请注意备份)。
注:删log之前确保innodb_fast_shutdown的值不是2,如果是2则需要先改为1,然后重启使之生效,再关闭mysql删log文件。其默认值是1。
#2
innodb 这个设置过了 还是不行啊
#3
错误日志中的内容是什么
#4
我改了innodb 这个设置 还是提示如题所示
#5
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'
#6
这个是最主要的吧 应该
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
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