mysql update failed, now apache also down---

[vindsl]

Hello,
(Happy sysadmin day btw!)

I tried to update Mysql from 4.0 to 5.1 via WHM but i got the following error near the start of the process:

=========================
'ERROR: 1136 Column count doesn't match value count at row 1
071126 20:49:18 [ERROR] Aborting '
=========================

And the update failed, and also i think the process tried to recompile apache and PHP because i cant start/restart httpd either.

If i try to recompile Apache, i get the following error:

=======================
Fetching http://httpupdate.cpanel.net/syspkgs...ntOS-Base.repo (0)....@75.127.84.226......connected......receiving...100%......Done
checkyum version 20.5
checkyum version 20.5
!! Package system can not be repaired automatically !!

and....

Apache Restart Output:
Syntax error on line 9 of /usr/local/apache/conf/php.conf:
Cannot load /usr/local/apache/libexec/libphp4.so into server: /usr/lib/libmysqlclient.so.14: version `libmysqlclient_14' not found (required by /usr/local/apache/libexec/libphp4.so)
/etc/init.d/httpd start: httpd could not be started
=======================

So both daemons are unresponsive now,
I tried mysqlup --force.. still the same..

anyone halp? =)
is there a way to really really force a apache and mysql reinstall? seems both of them are broken now :/

[jeffmonte]

I have had a same situation, I just made a backup of mysql databases.

cp -rp /var/lib/mysql /var/lib/mysql.back

Then I just moved the actual mysql directory to some other dir.

cd /var/lib

Then mv mysql mysql.bk

Then I just ran /scripts/mysqlup --force

As the way, it just fixed up.

Then I just copied the databases to the actual mysql dir.

I assume the issue is with the mysql database in which the tables are not being allowed to get altered.

Try this as this is one of my strategy...