After upgrading to 5.5 and running now for a few weeks. Everything seems to be running fine. Last night the sytem locked up and not mysql will not start back up.

Disk space is fine.

syslog part for the mysql is:

Sep 2 07:14:27 MBE mysqld_safe[3202]: started
Sep 2 07:14:27 MBE mysqld[3205]: 080902 7:14:27 InnoDB: Database was not shut down normally!
Sep 2 07:14:27 MBE mysqld[3205]: InnoDB: Starting crash recovery.
Sep 2 07:14:27 MBE mysqld[3205]: InnoDB: Reading tablespace information from the .ibd files...
Sep 2 07:14:27 MBE mysqld[3205]: InnoDB: Restoring possible half-written data pages from the doublewrite
Sep 2 07:14:27 MBE mysqld[3205]: InnoDB: buffer...
Sep 2 07:14:27 MBE mysqld[3205]: 080902 7:14:27 InnoDB: Starting log scan based on checkpoint at
Sep 2 07:14:27 MBE mysqld[3205]: InnoDB: log sequence number 0 113826.
Sep 2 07:14:27 MBE mysqld[3205]: InnoDB: Doing recovery: scanned up to log sequence number 0 113826
Sep 2 07:14:27 MBE mysqld[3205]: 080902 7:14:27 InnoDB: Started; log sequence number 0 113826
Sep 2 07:14:27 MBE mysqld[3205]: 080902 7:14:27 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/host.frm'
Sep 2 07:14:27 MBE mysqld[3205]: 080902 7:14:27 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './mysql/host.frm'
Sep 2 07:14:27 MBE mysqld[3205]: 080902 7:14:27 [ERROR] Fatal error: Can't open and lock privilege tables: Incorrect information in file: './mysql/host.frm'
Sep 2 07:14:27 MBE mysqld_safe[3216]: ended
Sep 2 07:14:28 MBE ntpdate[2903]: step time server 128.10.19.24 offset -0.476778 sec
Sep 2 07:14:41 MBE /etc/init.d/mysql[3351]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Sep 2 07:14:41 MBE /etc/init.d/mysql[3351]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Sep 2 07:14:41 MBE /etc/init.d/mysql[3351]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Sep 2 07:14:41 MBE /etc/init.d/mysql[3351]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sep 2 07:14:41 MBE /etc/init.d/mysql[3351]:

Any help would be great!

I see this is happened to several people.. I have done all the check and repaired the errors but I still can't start mysql.

is obviously the key.

A five second google led me to http://forums.mysql.com/read.php?10,172399,172572#msg-172572

_________________
*********************
LinHES 7.4
Australian Dragon
*********************

Yea, I just reinstalled. All that DB stuff is way over my head unless it written step by step..