ali aboos

echo "- - -" > /sys/class/scsi_host/host#/scan

Replace host# with number of your scsi adapter… sda would be host1, sdb host2 and so on.

mysqlcheck -u root -p --auto-repair --optimize --all-databases

You will be asked for root password and command will run. If you want to do it through cron, put your password immediately after -p… like -ppassword.

Everyone hates vi… I sure do. If you can’t or don’t want to permanently change your crontab editor use this:
env EDITOR=nano crontab -e

This should do it:
yum install perl gcc make kernel-headers kernel-devel audit binutils glibc-headers

If vmware tools install cannot find your linux headers, throw these in too and try again:
yum install kernel-headers-`uname -r` kernel-devel-`uname -r`

MySQL installation gets upgraded during your OS upgrade as well… therefore a few different things could cause the server to not start. I’d start troubleshooting this way:

Incompatible configuration: simply backup your /etc/mysql/my.cnf and copy a new one from /etc/mysql/my.cnf.dpkg-dist and start the server.
cp /etc/mysql/my.cnf /etc/mysql/my.cnf.bak
cp /etc/mysql/my.cnf.dpkg-dist /etc/mysql/my.cnf
/etc/init.d/mysql restart
 

Missing loopback interface: MySQL binds to your loopback interface by default and would not start if it is missing. Check yours and add if necessary:
nano /etc/network/interfaces
and add “lo” to lines with “auto”. If your interface line is “auto eth0” change it to read “auto lo eth0”. Also add “iface lo inet loopback” to the file if it is missing. Save config and restart the server.

2nd last resort: install MySQL: Install it again, see what happens.
aptitude install mysql-server-5.1
 

Last resort: completely purge the install and install again:
aptitude remove --purge mysql-server
aptitude install mysql-server
and if none of the above worked keep googling… good luck!