mysql 不 能启动的原因

英文的自己翻译一下

1. Obviously the 'ole check the log file for anything nasty
 
cat /var/log/mysqld.log

查看日志文件

本来想贴错误日志来，但是 本人懒 找不到了

基本意思是不能写入pid，空间不足，于是删除了一下 视频文件就可以，

硬盘这么大为啥 放不开点视频文件能，分区分的不好 当时分区的时候就安装默认分区安装了，只分了根分区，和home 虚拟内存

根分区分的少， 然后就装不开了，

回去好好对鸟哥好好规划一下分区，

 

 

 

 

 
2. Stop the service
 
service mysqld stop

当执行这个时候 显示 demom 超时
 
3. Check to see if the service stopped, it might be calling the wrong pid.
 
ps aux | grep mysql

确实有 mysql的id
 
4. Kill any mysql process that might still be running.
 
kill -9 ??? ??? 也kill了

最后没办法了重启也不行
 
5. (*CAREFUL*) Remove/move/backup any databases from the data directory, only do this step if you need to.
 
rm -Rf /var/lib/mysql/*
 
6. Check your global options configuration file, should be similar to stevanbt's initial post.
 
cat /etc/my.cnf
 
7. Copy over one of the preconfigured 'sample' server-specific options file. Global (/etc/my.cnf) file has priority over server-specific file, but these have more options in them and have been tuned for a certain role.
 
cp /usr/share/doc/mysql-server-?.??.??/my-small.cnf /var/lib/mysql
 
8. Recreate the initial databases, this step is optional as the initscripts will do this anyway.
 
mysql_install_db
 
9. Check and set the runlevels for the service.
 
chkconfig --level 345 mysqld on
chkconfig --list mysqld
 
10. Start the service.
 
service mysqld start
 
11. Check the log file (step 1)

本篇文章来源于 Linux公社网站(www.linuxidc.com)  原文链接：http://www.linuxidc.com/Linux/2008-04/12537.htm