Results 1 to 4 of 4

Thread: mysql crashes

  1. #1
    amorgan is offline Active Member
    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
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Which ones are being shown as corrupted ?

  3. #3
    amorgan is offline Active Member
    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
    uxbod's Avatar
    uxbod is offline Moderator
    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.

Thread Information

Users Browsing this Thread

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

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, 02: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
  •