MySQL启动故障排除-优快云博客

今天安装新数据库 mysql-5.5.16 结果忘记配置一个目录,导致mysql启动失败

111108 16:19:54 mysqld_safe Starting mysqld daemon with databases from /home/soft/mysql/data
/opt/soft/mysql/bin/mysqld: File '/opt/soft/mysql/binlog/mysql-bin.index' not found (Errcode: 2)
111108 16:19:54 [ERROR] Aborting

111108 16:19:54 [Note] /opt/soft/mysql/bin/mysqld: Shutdown complete

111108 16:19:54 mysqld_safe mysqld from pid file /opt/soft/mysql/601.localdomain.pid ended

创建目录后怎么都启动不起来了....

111108 16:25:54 mysqld_safe Starting mysqld daemon with databases from /home/soft/mysql/data
/opt/soft/mysql/bin/mysqld: Table 'mysql.plugin' doesn't exist
111108 16:25:54 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
111108 16:25:54 InnoDB: The InnoDB memory heap is disabled
111108 16:25:54 InnoDB: Mutexes and rw_locks use GCC atomic builtins
111108 16:25:54 InnoDB: Compressed tables use zlib 1.2.3
111108 16:25:54 InnoDB: Initializing buffer pool, size = 128.0M
111108 16:25:54 InnoDB: Completed initialization of buffer pool
111108 16:25:54 InnoDB: Log file /opt/soft/mysql/log/ib_logfile0 did not exist: new to be created
InnoDB: Setting log file /opt/soft/mysql/log/ib_logfile0 size to 512 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500
111108 16:25:58 InnoDB: Log file /opt/soft/mysql/log/ib_logfile1 did not exist: new to be created
InnoDB: Setting log file /opt/soft/mysql/log/ib_logfile1 size to 512 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500
111108 16:26:00 InnoDB: Log file /opt/soft/mysql/log/ib_logfile2 did not exist: new to be created
InnoDB: Setting log file /opt/soft/mysql/log/ib_logfile2 size to 512 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500
111108 16:26:01 InnoDB: Cannot initialize created log files because
111108 16:26:01 InnoDB: data files are corrupt, or new data files were
111108 16:26:01 InnoDB: created when the database was started previous
111108 16:26:01 InnoDB: time but the database was not shut down
111108 16:26:01 InnoDB: normally after that.
111108 16:26:01 [ERROR] Plugin 'InnoDB' init function returned error.
111108 16:26:01 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111108 16:26:01 [ERROR] Unknown/unsupported storage engine: innodb
111108 16:26:01 [ERROR] Aborting

111108 16:26:01 [Note] /opt/soft/mysql/bin/mysqld: Shutdown complete

111108 16:26:01 mysqld_safe mysqld from pid file /opt/soft/mysql/601.localdomain.pid ended