To repair all database at one go you need to run below commands,

mysqlcheck –all-databases -r #repair
mysqlcheck –all-databases -a #analyze
mysqlcheck –all-databases -o #optimize

Error   “Manager of pid-file quit without updating fi”

If you get this error.

# ps -ef | grep mysql

# killall  mysql

go to cd /var/lib/mysql/mysql

myisamchk -r *.MYI

Once done  /etc/init.d/mysql restart

If you receive the above error while compiling any package , it means  that the /tmp partition is mounted in “noexec” mode and that you do not have permissions to execute anything under /tmp partition.

Execute the “mount” command and you will see something like:

root@server [~]# mount
/dev/sdax on /tmp type ext3 (rw,noexec,nosuid)

To mount the /tmp partition in rw mode, execute:

root@server [~]# mount -o remount rw /tmp

Now, you can execute the “pecl” command to install the package you like. Once done, you can remount /tmp with noexec mode again:

root@server [~]# mount -o remount rw,noexec,nosuid /tmp