Oops.. sorry about the exposed password.. i should know better.
The error that appears most in the .err file (very big file) is
080523 11:01:35 InnoDB: Error: page 1 log sequence number 20 4035350367
InnoDB: is in the future! Current system log sequence number 20 4022856577.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB:
MySQL :: MySQL 5.0 Reference Manual :: 13.2.8.1 Forcing InnoDB Recovery
InnoDB: for more information.
I've edited the /opt/zimbra/conf/my.cnf to reference 127.0.0.1 instead of "localhost".. im trying an upgrade to 5.0.0 to see if it works..