Results 1 to 3 of 3

Thread: Upgrade from 6.06 - MySQL Error 1146 Table doesn't exist

  1. #1
    jzardo is offline Starter Member
    Join Date
    Nov 2012
    Posts
    2
    Rep Power
    2

    Default Upgrade from 6.06 - MySQL Error 1146 Table doesn't exist

    Hello All, how are you?

    Im trying to upgrade a Zimbra OSE from 6.06 but upgrade fails as I have a MySQL table that needs repair.

    mboxgroup20.imap_message
    Error : Table 'mboxgroup20.imap_message' doesn't exist

    I already tried to dump this table with:

    /opt/zimbra/mysql/bin/mysqldump --socket=/opt/zimbra/db/mysql.sock -u root -p mboxgroup20

    But this command gives me the same error:

    mysqldump: Got error: 1146: Table 'mboxgroup20.imap_message' doesn't exist when using LOCK TABLES

    I tried to search in some MySQL forums but have no success find a right solution so far.

    Anybody had a similar issue? How do you resolved? Any tips?

    Thanks in advance.

    Regards,

    JZardo

  2. #2
    inqueue is offline Zimbra Employee
    Join Date
    Mar 2006
    Location
    Greenwood, IN
    Posts
    90
    Rep Power
    9

    Default

    Hello,

    Does mysql indicate the table is present?

    Code:
    mysql mboxgroup20 -e 'show tables'
    You may need to drop the table and recreate to get it going.
    --
    Jason Bryan
    Zimbra R&D

  3. #3
    jzardo is offline Starter Member
    Join Date
    Nov 2012
    Posts
    2
    Rep Power
    2

    Default

    Hi Jason,

    Thanks for reply.

    Code:
    [zimbra@mail ~]$ mysql mboxgroup20 -e 'show tables'
    +-----------------------+
    | Tables_in_mboxgroup20 |
    +-----------------------+
    | appointment           |
    | data_source_item      |
    | imap_folder           |
    | imap_message          |
    | mail_item             |
    | open_conversation     |
    | pop3_message          |
    | revision              |
    | tombstone             |
    +-----------------------+
    Right now Im doing zmmailbox backups from accounts in this mboxgroup to delete them and drop table to recreate it.

    Regards,

    Jeff

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 07-13-2012, 10:49 AM
  2. Corrupt database? Table mboxgroupXX.revision doesn't exist
    By loginrl103 in forum Administrators
    Replies: 4
    Last Post: 05-16-2012, 06:08 AM
  3. Corrupt database? Table mboxgroupXX.revision doesn't exist
    By loginrl103 in forum Error Reports
    Replies: 0
    Last Post: 05-16-2012, 01:44 AM
  4. MySQL Table Upgrade - Is it necessary?
    By jv494 in forum Administrators
    Replies: 6
    Last Post: 02-24-2012, 12:46 AM
  5. Problem with MYSQL "mysql.host doesn't exist
    By kaltera in forum Installation
    Replies: 4
    Last Post: 06-04-2010, 12:58 PM

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
  •