centos6.5 x64 位测试机一台。突然掉电。现在上电后发现mysql的3307进程无法启动。
能够启动的mysql 3306实例情况为
# ps -ef|grep mysql
root 6504 1 0 11:53 pts/5 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --datadir=/usr/local/mysql/data --pid-file=/usr/local/mysql/data/sms.api.ywl.internal.com.pid
mysql 6840 6504 0 11:53 pts/5 00:00:00 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --plugin-dir=/usr/local/mysql/lib/plugin --user=mysql --log-error=/usr/local/mysql/data/sms.api.ywl.internal.com.err --pid-file=/usr/local/mysql/data/sms.api.ywl.internal.com.pid --socket=/usr/local/mysql/data/mysql.sock --port=3306
root 9324 5526 0 12:43 pts/4 00:00:00 grep mysql
mysql 3307的安装为二进制包解压安装。解压,修改配置文件,初始化,设置权限。(详细过程参考 centos6上mysql5.6二进制包安装)