Hi.. i've sorted it out.. it was a corrupt database table in zimbra-4.5.10..
I tried running /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=**** --auto-repair
manually but it still failed.
Googling thru mysql docs online led me to adding "innodb_force_recovery = 4" to the [mysqld] section of the /opt/zimbra/conf/my.cnf file,
starting and stopping zimbra, then i "#"-ed out the "innodb_force_recovery = 4" line again, and restarted zimbra normally.
I now ran the upgrade and it ran smoothly,.. i upgraded from 4.5.10 to the current 5.0.6 latest edition.
Its up and running now, but i shall be watching it closely in the days to come. somehow i dont think i'll have any problems
I hope this helps someone else..
cheers