MYSQL服务器无法启动
错误日志如下，军哥，求救。折磨了一天了。150320 16:22:16InnoDB: Starting shutdown...150320 16:22:16InnoDB: Shutdown completed; log sequence number 1595675
150320 16:22:16 /usr/local/mysql/bin/mysqld: Shutdown complete
150320 16:22:16 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZ94saqjwjzZ.pid ended
150320 16:23:13 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
150320 16:23:13 InnoDB: The InnoDB memory heap is disabled
150320 16:23:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150320 16:23:13 InnoDB: Compressed tables use zlib 1.2.8
150320 16:23:13 InnoDB: Initializing buffer pool, size = 16.0M
150320 16:23:13 InnoDB: Completed initialization of buffer pool
150320 16:23:13 InnoDB: highest supported file format is Barracuda.
150320 16:23:13InnoDB: Waiting for the background threads to start
150320 16:23:14 InnoDB: 5.5.37 started; log sequence number 1595675
/usr/local/mysql/bin/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
150320 16:23:14 Failed to open log (file './mysql-bin.000008', errno 2)
150320 16:23:14 Could not open log file
150320 16:23:14 Can't init tc log
150320 16:23:14 Aborting
150320 16:23:14InnoDB: Starting shutdown...
150320 16:23:15InnoDB: Shutdown completed; log sequence number 1595675
150320 16:23:15 /usr/local/mysql/bin/mysqld: Shutdown complete
150320 16:23:15 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZ94saqjwjzZ.pid ended
150320 16:50:51 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var
150320 16:50:51 InnoDB: The InnoDB memory heap is disabled
150320 16:50:51 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150320 16:50:51 InnoDB: Compressed tables use zlib 1.2.8
150320 16:50:51 InnoDB: Initializing buffer pool, size = 16.0M
150320 16:50:51 InnoDB: Completed initialization of buffer pool
150320 16:50:51 InnoDB: highest supported file format is Barracuda.
150320 16:50:51InnoDB: Waiting for the background threads to start
150320 16:50:52 InnoDB: 5.5.37 started; log sequence number 1595675
/usr/local/mysql/bin/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
150320 16:50:52 Failed to open log (file './mysql-bin.000008', errno 2)
150320 16:50:52 Could not open log file
150320 16:50:52 Can't init tc log
150320 16:50:52 Aborting
150320 16:50:52InnoDB: Starting shutdown...
150320 16:50:52InnoDB: Shutdown completed; log sequence number 1595675
150320 16:50:52 /usr/local/mysql/bin/mysqld: Shutdown complete
150320 16:50:52 mysqld_safe mysqld from pid file /usr/local/mysql/var/iZ94saqjwjzZ.pid ended /usr/local/mysql/bin/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
150320 16:50:52 Failed to open log (file './mysql-bin.000008', errno 2)
150320 16:50:52 Could not open log file
日志文件被非正常方法删除了，把其他的几个mysql-bin.00000*日志删除，然后清空一下mysql-bin.index文件，重启mysql应该就可以了
页:
[1]