Results 1 to 3 of 3

Thread: Upgrade database error

  1. #1
    Join Date
    Nov 2009
    Posts
    2
    Rep Power
    5

    Default Upgrade database error

    I am trying to upgrade our existing zimbra installation (ZCS 6.0.9) to ZCS 7.1.3 which is running on Ubuntu 8.04.3, however during the upgrade procedure it runs a database integrity check and I receive the following error:

    Code:
    Database errors found.
    /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=xxxxxxxx --auto-repair
    mboxgroup79.mail_item
     error    : Corrupt
     mboxgroup79.mail_item
     note     : The storage engine for the table doesn't support repair
    I have tried running through a procedure on the wiki Mysql Crash Recovery (alternate method) - Zimbra :: Wiki however when it gets to the section where you dump the individual errors out to /tmp/XX all the files are 0 size, so there doesn't appear to be anything for me to fix.

  2. #2
    Join Date
    Nov 2009
    Posts
    2
    Rep Power
    5

    Default

    Anyone have any ideas? Can't seem to repair it but I don't know if it will cause nay problems if I just ignore it and carry on with the update.

  3. #3
    Join Date
    Jun 2010
    Posts
    126
    Rep Power
    5

    Default

    login to mysql, use the db with the issue and try running: OPTIMIZE TABLE mail_item;

Similar Threads

  1. Replies: 5
    Last Post: 05-11-2012, 02:16 PM
  2. Upgrade from 6.0.10 to 7 beta4
    By alex70 in forum Installation
    Replies: 14
    Last Post: 05-11-2012, 02:02 PM
  3. Database integrity check
    By mludwig in forum Administrators
    Replies: 4
    Last Post: 08-15-2011, 02:56 AM
  4. Replies: 6
    Last Post: 03-14-2011, 04:21 AM
  5. [SOLVED] New zcs 7 install : database errors founds
    By dkbk in forum Administrators
    Replies: 4
    Last Post: 03-01-2011, 05:49 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •