Results 1 to 3 of 3

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

Hybrid View

  1. #1
    Join Date
    Nov 2012
    Posts
    2
    Rep Power
    3

    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
    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
    Join Date
    Nov 2012
    Posts
    2
    Rep Power
    3

    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

Similar Threads

  1. Replies: 2
    Last Post: 07-13-2012, 11:49 AM
  2. Corrupt database? Table mboxgroupXX.revision doesn't exist
    By loginrl103 in forum Administrators
    Replies: 4
    Last Post: 05-16-2012, 07:08 AM
  3. Corrupt database? Table mboxgroupXX.revision doesn't exist
    By loginrl103 in forum Error Reports
    Replies: 0
    Last Post: 05-16-2012, 02: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, 01: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
  •