解决方案 »
- 请问怎样建商品表?
- MySQL4.0.21数据迁移至MySQL5的疑问(使用MySQLdump)
- Linux开发程序,用哪种语言比较方便?
- mysql存储过程是如何运行的?
- 请问auto_increment
- PHP中用mysql_query("call abc()")調用存儲過程,可就是調不到???
- 请教使用innodb表的数据库备份与恢复?
- mysql 与 ms-sql server 能互相转换吗?
- 寒假想学数据库方面的东西,我应该从mysql入手,还是foxpro,还是纯理论的??给些建议吧,“高程”关于数据库都考些什么?
- 我申请的51.net的收费空间.mysql没有办法使用。
- mysql group by 查询的问题
- 就命啊 用xampp调试无法打开数据库
以下是mysql日志:
InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
121217 7:28:43 InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
121217 7:28:43 InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 27 MB
InnoDB: Database physically writes the file full: wait...
121217 7:28:44 InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 27 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
121217 7:28:45 InnoDB: Started; log sequence number 0 0
121217 7:28:45 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
121225 11:55:21 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown121225 11:55:28 InnoDB: Starting shutdown...
121225 11:55:31 InnoDB: Shutdown completed; log sequence number 0 196931
121225 11:55:31 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete121225 11:58:41 InnoDB: Started; log sequence number 0 196931
121225 11:58:42 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
121226 14:00:31 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown121226 14:00:31 InnoDB: Starting shutdown...
121226 14:00:33 InnoDB: Shutdown completed; log sequence number 0 196941
121226 14:00:33 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete121226 14:03:54 InnoDB: Started; log sequence number 0 196941
121226 14:04:02 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
130215 14:01:27 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown130215 14:01:28 InnoDB: Starting shutdown...
130215 14:01:32 InnoDB: Shutdown completed; log sequence number 0 199469252
130215 14:01:32 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete130215 14:08:30 InnoDB: Started; log sequence number 0 199469252
130215 14:08:30 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
130217 10:25:16 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130217 10:25:17 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 211260012.
InnoDB: Doing recovery: scanned up to log sequence number 0 211260012
130217 10:25:17 InnoDB: Started; log sequence number 0 211260012
130217 10:25:17 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
130218 6:54:41 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown130218 6:54:41 InnoDB: Starting shutdown...
130218 6:54:42 InnoDB: Shutdown completed; log sequence number 0 223266687
130218 6:54:42 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete130218 7:04:06 InnoDB: Started; log sequence number 0 223266687
130218 7:04:07 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
130218 7:12:25 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130218 7:12:25 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 223283807.
InnoDB: Doing recovery: scanned up to log sequence number 0 223283807
130218 7:12:25 InnoDB: Started; log sequence number 0 223283807
130218 7:12:25 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
130421 23:34:50 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130421 23:34:51 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 2233199598.
InnoDB: Doing recovery: scanned up to log sequence number 0 2233199598
130421 23:34:51 InnoDB: Started; log sequence number 0 2233199598
130421 23:34:51 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
130422 0:32:50 [ERROR] Got error 127 when reading table './zhushou/app_goods'
130422 0:32:50 [ERROR] Got error 127 when reading table './zhushou/app_goods'
130422 0:32:50 [ERROR] Got error 127 when reading table './zhushou/app_goods'
130422 10:07:15 [Note] Found 363221 of 363222 rows when repairing './zhushou/app_goods'
130512 14:05:29 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown130512 14:05:31 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 496337 user: 'zhushou'130512 14:05:31 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 496103 user: 'zhushou'130512 14:05:31 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 64 user: 'zhushou'130512 14:05:32 InnoDB: Starting shutdown...
130512 14:05:36 InnoDB: Shutdown completed; log sequence number 0 2329775174
130512 14:05:36 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete130512 14:14:26 InnoDB: Started; log sequence number 0 2329775174
130512 14:14:26 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
130522 14:50:42 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown130522 14:50:44 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 460632 user: 'zhushou'130522 14:50:44 InnoDB: Starting shutdown...
130522 14:50:51 InnoDB: Shutdown completed; log sequence number 0 2360847011
130522 14:50:51 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete130522 14:53:44 InnoDB: Started; log sequence number 0 2360847011
130522 14:53:45 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
130527 8:36:17 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown130527 8:36:20 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 186009 user: 'zhushou'130527 8:36:20 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 1346 user: 'zhushou'130527 8:36:21 InnoDB: Starting shutdown...
130527 8:36:25 InnoDB: Shutdown completed; log sequence number 0 2361430709
130527 8:36:25 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete130527 8:38:49 InnoDB: Started; log sequence number 0 2361430709
130527 8:38:49 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
130528 16:13:54 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown130528 16:13:56 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 49959 user: 'zhushou'130528 16:13:56 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 60 user: 'zhushou'130528 16:13:56 InnoDB: Starting shutdown...
130528 16:14:01 InnoDB: Shutdown completed; log sequence number 0 2361564451
130528 16:14:01 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete130528 16:16:24 InnoDB: Started; log sequence number 0 2361564451
130528 16:16:25 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
130529 1:10:02 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown130529 1:10:07 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 15024 user: 'zhushou'130529 1:10:07 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 177 user: 'zhushou'
skip-locking
skip-name-resolve
130614 14:10:56 InnoDB: Started; log sequence number 0 2375635739
130614 14:10:56 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
130614 15:01:06 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8558 user: 'zhushou'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8469 user: 'liu'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8450 user: 'zhushou'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8428 user: 'zhushou'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8320 user: 'zhushou'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8207 user: 'zhushou'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8177 user: 'zhushou'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8154 user: 'zhushou'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 8026 user: 'zhushou'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 6963 user: 'zhushou'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 3421 user: 'zhushou'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 3380 user: 'zhushou'130614 15:01:09 [Warning] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Forcing close of thread 3346 user: 'zhushou'130614 15:01:09 InnoDB: Starting shutdown...
130614 15:01:11 InnoDB: Shutdown completed; log sequence number 0 2375666530
130614 15:01:11 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete130614 15:01:12 InnoDB: Started; log sequence number 0 2375666530
130614 15:01:12 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.22-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)