Results 1 to 4 of 4

Thread: mysql crashes

  1. #1
    Join Date
    Jun 2008
    Posts
    26
    Rep Power
    7

    Default mysql crashes

    One of my hard drives failed in the RAID 5 array in my server today. Apparently it corrupted some of my mysql tables before it failed. I tried following the steps posted at Mysql Crash Recovery - Zimbra :: Wiki, but when trying to drop the databases there were 3 or 4 databases that couldn't be dropped. I keep getting 2013 errors when trying to drop them.

    I'm running ZCS-5.0.10 FOSS on CentOS 5.2. Any ideas on how to drop these databases? Is this possibly a problem with the mysql itself and if so is there a way I can easily remove and reinstall just it?

  2. #2
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Which ones are being shown as corrupted ?

  3. #3
    Join Date
    Jun 2008
    Posts
    26
    Rep Power
    7

    Default

    It's 3 of the mboxgroup databases, I think mboxgroup64, mboxgroup75, and mboxgroup76.

  4. #4
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Try dropping them again. Did you get any error messages when you dumped them ? Also check /opt/zimbra/log/mysql_error.log for additional information.

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. [SOLVED] Install Problem in Ubuntu 6.06 Server
    By xtimox in forum Installation
    Replies: 16
    Last Post: 03-27-2008, 09:36 AM
  3. DNS Questions and Trouble Installing
    By smurraysb in forum Installation
    Replies: 22
    Last Post: 03-14-2008, 03:27 PM
  4. Replies: 18
    Last Post: 03-20-2006, 01:22 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
  •