I've been trying to upgrade from 4.0.3.GA to 4.5.x since they came out. The dev guys have been supportive and told me to do some tasks to find out if any of my DB's were corrupt. Turns out that they are (somehow they got munged up). They've asked me to drop the corrupt DB's and then test the upgrade process. The problem is that I'm not a mysql admin type and everything that I've tried doesn't work.
I've tried issuing a "drop database;" and "use database; drop table xxxx;" and even going to the /opt/zimbra/db/data directories and deleting the mailboxes that were found to be corrupt. None of these worked. I'm attaching a log of a complete upgrade process where I try these things.
Can someone point me to how to drop these tables so that I can upgrade my system?
ps I've also stood up a separate 4.5.3 system and tried to use imapsync to copy users stuff over, but it seems to get stuck on some mailboxes and I get a "broken pipe" error from imapsync. Anyone ever get this one? I've looked around but can't seem to find any workaround for this either. Thanks!