Results 1 to 7 of 7

Thread: MySQL recovery

  1. #1
    hodd is offline Active Member
    Join Date
    Jun 2008
    Posts
    45
    Rep Power
    7

    Default MySQL recovery

    So I upgraded one of my MTA's this morning to 6.0.9, and for some reason the upgrade was getting stuck on Starting Mysql. Everything I've read points to a corrupt database.

    Everything I found points to the Mysql Crash Recovery

    When I get to this step:
    mysql --batch --skip-column-names -e "show databases" | grep -e mbox -e zimbra > /tmp/mysql.db.list

    I get the error below:
    [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist


    I've got a call into support with a server down, but just wanted to reachout to the forums to see if anyone can help as well...
    OS : Ubuntu 6.02 LTS
    ZCS : zcs-NETWORK-6.0.8_GA_2661.UBUNTU6

  2. #2
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,504
    Rep Power
    57

    Default

    It really depends on what your exact problem is, there's a couple of threads marked as 'Solved' here: site:zimbra.com +"Fatal error: Can't open and lock privilege tables: Table 'mysql.host'" - Yahoo! Search Results
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    FritzBrause is offline Partner (VAR/HSP)
    Join Date
    Jan 2008
    Location
    Berlin, Germany
    Posts
    203
    Rep Power
    7

    Default

    If your MySQL Server is not starting you may try to repair the table by

    Code:
    /opt/zimbra/mysql/bin/myisamchk -r /opt/zimbra/db/data/mysql/*.MYI
    This can fix almost anything on an MyISAM table.
    Best regards

    Andreas Wolske

    managedhosting.de GmbH

    Zimbra Cloud Hosting, Consulting & Support
    VMware vCloud Powered Serviceprovider

  4. #4
    hodd is offline Active Member
    Join Date
    Jun 2008
    Posts
    45
    Rep Power
    7

    Default

    So it turned out that I accidently rm -rf'd the SQL logs...it's was all bad. Even though I ctrl+c'd very quickly when I saw what I had typed, I had to work with support on rebuilding the mysql tables.
    OS : Ubuntu 6.02 LTS
    ZCS : zcs-NETWORK-6.0.8_GA_2661.UBUNTU6

  5. #5
    malayo is offline Special Member
    Join Date
    Apr 2011
    Posts
    117
    Rep Power
    4

    Default

    how it was done? zmsetup.pl and choose to only install mysql?

  6. #6
    FritzBrause is offline Partner (VAR/HSP)
    Join Date
    Jan 2008
    Location
    Berlin, Germany
    Posts
    203
    Rep Power
    7

    Default

    Quote Originally Posted by malayo View Post
    how it was done? zmsetup.pl and choose to only install mysql?
    ... that will be not necessary in most cases. If you only deleted the InnoDB transaction logs

    Code:
    /opt/zimbra/db/data/ib_logfile0
    /opt/zimbra/db/data/ib_logfile1
    than stopping Zimbra via "zmcontrol stop" is. O.K. As second step only start and stop the Database (as the zimbra user)

    Code:
    mysql.server start
    mysql
    mysql> show innidb status\G
    mysql> quit
    mysql.server stop
    zmcontrol start
    if nothing else is corrupted, restarting the MySQL Server will recreate the InnoDB transaction logs. If this doesn't lead to success, there's something else.
    Best regards

    Andreas Wolske

    managedhosting.de GmbH

    Zimbra Cloud Hosting, Consulting & Support
    VMware vCloud Powered Serviceprovider

  7. #7
    malayo is offline Special Member
    Join Date
    Apr 2011
    Posts
    117
    Rep Power
    4

    Default

    thanks, apparently my problem of mysql.server and mailboxd would not stated as running was causing by not using right mysql password after copying localconfig.xml from old server for migration purposes (centos 5 to centos 6 because zcs 8 only runs on centos 6)

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 23
    Last Post: 01-24-2013, 03:44 PM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  3. [SOLVED] Install Problem in Ubuntu 6.06 Server
    By xtimox in forum Installation
    Replies: 16
    Last Post: 03-27-2008, 09:36 AM
  4. DNS Questions and Trouble Installing
    By smurraysb in forum Installation
    Replies: 22
    Last Post: 03-14-2008, 03:27 PM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 06:59 PM

Posting Permissions

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