ERROR! MySQL manager or server PID file could not be found! Starting MySQL.....

wdlinux

在mysql 安装目录下

新建 /home/wddata/var  文件即可  mysql-bin.000008

 

141026 20:13:49 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.61/var
141026 20:13:49 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141026 20:13:49 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141026 20:13:50  InnoDB: Initializing buffer pool, size = 8.0M
141026 20:13:50  InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
141026 20:13: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...
141026 20:13:50  InnoDB: Started; log sequence number 0 44243
/www/wdlinux/mysql-5.1.61/libexec/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
141026 20:13:50 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
141026 20:13:50 [ERROR] Could not open log file
141026 20:13:50 [ERROR] Can't init tc log
141026 20:13:50 [ERROR] Aborting

141026 20:13:50  InnoDB: Starting shutdown...
141026 20:13:55  InnoDB: Shutdown completed; log sequence number 0 44243
141026 20:13:55 [Note] /www/wdlinux/mysql-5.1.61/libexec/mysqld: Shutdown complete

141026 20:13:55 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.61/var/ebs-28575.pid ended
141029 20:12:20 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.61/var
141029 20:12:20 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141029 20:12:20 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141029 20:12:20  InnoDB: Initializing buffer pool, size = 8.0M
141029 20:12:20  InnoDB: Completed initialization of buffer pool
141029 20:12:20  InnoDB: Started; log sequence number 0 44243
/www/wdlinux/mysql-5.1.61/libexec/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
141029 20:12:20 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
141029 20:12:20 [ERROR] Could not open log file
141029 20:12:20 [ERROR] Can't init tc log
141029 20:12:20 [ERROR] Aborting

141029 20:12:20  InnoDB: Starting shutdown...
141029 20:12:26  InnoDB: Shutdown completed; log sequence number 0 44243
141029 20:12:26 [Note] /www/wdlinux/mysql-5.1.61/libexec/mysqld: Shutdown complete

141029 20:12:26 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.61/var/ebs-28575.pid ended
141101 11:51:17 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.61/var
141101 11:51:18 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 11:51:18 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 11:51:18  InnoDB: Initializing buffer pool, size = 8.0M
141101 11:51:18  InnoDB: Completed initialization of buffer pool
141101 11:51:19  InnoDB: Started; log sequence number 0 44243
/www/wdlinux/mysql-5.1.61/libexec/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
141101 11:51:19 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
141101 11:51:19 [ERROR] Could not open log file
141101 11:51:19 [ERROR] Can't init tc log
141101 11:51:19 [ERROR] Aborting

wdlinux  下数据库文件位置


/home/wddata/var



141101 11:51:19  InnoDB: Starting shutdown...
141101 11:51:24  InnoDB: Shutdown completed; log sequence number 0 44243
141101 11:51:24 [Note] /www/wdlinux/mysql-5.1.61/libexec/mysqld: Shutdown complete

141101 11:51:24 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.61/var/ebs-28575.pid ended
141101 19:03:50 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.61/var
141101 19:03:50 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 19:03:50 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 19:03:50  InnoDB: Initializing buffer pool, size = 8.0M
141101 19:03:50  InnoDB: Completed initialization of buffer pool
141101 19:03:50  InnoDB: Started; log sequence number 0 44243
/www/wdlinux/mysql-5.1.61/libexec/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
141101 19:03:50 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
141101 19:03:50 [ERROR] Could not open log file
141101 19:03:50 [ERROR] Can't init tc log
141101 19:03:50 [ERROR] Aborting

141101 19:03:50  InnoDB: Starting shutdown...
141101 19:03:55  InnoDB: Shutdown completed; log sequence number 0 44243
141101 19:03:55 [Note] /www/wdlinux/mysql-5.1.61/libexec/mysqld: Shutdown complete

141101 19:03:55 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.61/var/ebs-28575.pid ended
141101 19:40:21 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.61/var
141101 19:40:21 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 19:40:21 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 19:40:21  InnoDB: Initializing buffer pool, size = 8.0M
141101 19:40:21  InnoDB: Completed initialization of buffer pool
141101 19:40:21  InnoDB: Started; log sequence number 0 44243
/www/wdlinux/mysql-5.1.61/libexec/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
141101 19:40:21 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
141101 19:40:21 [ERROR] Could not open log file
141101 19:40:21 [ERROR] Can't init tc log
141101 19:40:21 [ERROR] Aborting

141101 19:40:21  InnoDB: Starting shutdown...
141101 19:40:26  InnoDB: Shutdown completed; log sequence number 0 44243
141101 19:40:26 [Note] /www/wdlinux/mysql-5.1.61/libexec/mysqld: Shutdown complete

141101 19:40:26 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.61/var/ebs-28575.pid ended
141101 19:57:20 mysqld_safe Starting mysqld daemon with databases from /www/wdlinux/mysql-5.1.61/var
141101 19:57:20 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 19:57:20 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
141101 19:57:20  InnoDB: Initializing buffer pool, size = 8.0M
141101 19:57:20  InnoDB: Completed initialization of buffer pool
141101 19:57:20  InnoDB: Started; log sequence number 0 44243
/www/wdlinux/mysql-5.1.61/libexec/mysqld: File './mysql-bin.000008' not found (Errcode: 2)
141101 19:57:20 [ERROR] Failed to open log (file './mysql-bin.000008', errno 2)
141101 19:57:20 [ERROR] Could not open log file
141101 19:57:20 [ERROR] Can't init tc log
141101 19:57:20 [ERROR] Aborting

141101 19:57:20  InnoDB: Starting shutdown...
141101 19:57:26  InnoDB: Shutdown completed; log sequence number 0 44243
141101 19:57:26 [Note] /www/wdlinux/mysql-5.1.61/libexec/mysqld: Shutdown complete

141101 19:57:26 mysqld_safe mysqld from pid file /www/wdlinux/mysql-5.1.61/var/ebs-28575.pid ended