From - Tue Apr  8 07:51:30 2003
Return-Path: <owner-info-cyrus@lists.andrew.cmu.edu>
Delivered-To: mattesim@mobile.sauter-bc.com
Received: from mailhub.ch.sauter-bc.com (mailhub [10.1.6.26])
	by mobile.sauter-bc.com (Postfix) with ESMTP id 28BF613926
	for <mattesim@mobile.sauter-bc.com>; Mon,  7 Apr 2003 20:01:26 +0200 (CEST)
Received: from mx-01-bsl.sauter-bc.com (mx-01-bsl.sauter-bc.com [213.173.165.132])
	by mailhub.ch.sauter-bc.com (Postfix) with ESMTP id D06C032CB5
	for <simon.matter@ch.sauter-bc.com>; Mon,  7 Apr 2003 20:01:25 +0200 (CEST)
Received: from lists2.andrew.cmu.edu (LISTS2.andrew.cmu.edu [128.2.10.216])
	by mx-01-bsl.sauter-bc.com (Postfix) with ESMTP id 4F0944E245
	for <simon.matter@ch.sauter-bc.com>; Mon,  7 Apr 2003 20:01:25 +0200 (CEST)
Received: (from postman@localhost)
	by lists2.andrew.cmu.edu (8.12.9/8.12.0.Beta16) id h37HheNG026015
	for info-cyrus-list; Mon, 7 Apr 2003 13:43:40 -0400
Received: from polywog.navpoint.com (polywog.navpoint.com [207.106.42.31])
	by lists2.andrew.cmu.edu (8.12.9/8.12.0.Beta16) with ESMTP id h37HhdGL026012
	for <info-cyrus@lists.andrew.cmu.edu>; Mon, 7 Apr 2003 13:43:40 -0400
Received: from lo-tek.org (localhost.localdomain [127.0.0.1])
	by polywog.navpoint.com (8.11.6/8.11.6) with SMTP id h37HlWa31591;
	Mon, 7 Apr 2003 13:47:32 -0400
Received: from noir.jmc.tju.edu ([147.140.160.249])
        (SquirrelMail authenticated user erecio)
        by polywog.navpoint.com with HTTP;
        Mon, 7 Apr 2003 13:47:32 -0400 (EDT)
Message-ID: <49924.147.140.160.249.1049737652.squirrel@polywog.navpoint.com>
Date: Mon, 7 Apr 2003 13:47:32 -0400 (EDT)
Subject: Re: recovering from mailbox.db corruption cyrus 2_2
From: "E M Recio" <erecio@lo-tek.org>
To: <info-cyrus@lists.andrew.cmu.edu>
In-Reply-To: <3E91B665.4000701@omniti.com>
References: <3E91AE19.6080605@harvard.edu>
        <3E91B665.4000701@omniti.com>
X-Priority: 3
Importance: Normal
Cc: <edward_zarecor@harvard.edu>
X-Mailer: SquirrelMail (version 1.2.11)
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Sender: owner-info-cyrus@lists.andrew.cmu.edu
Precedence: bulk
Status:  O
X-Mozilla-Status: 8011
X-Mozilla-Status2: 00000000
X-UIDL: 3d95300f00011be2

> I hope that you have a flat text version as a backup.
>
> If you don't you can try to dump the mailbox file, mv the old mailbox.db
>  file out of the way, and then reimport the mailbox file.  Then run a
> reconstruct to make sure that everything is correct.
>
> Hope this helps,
> B


If you did lose the plain text file, then you'll need to recreate it.
here's how:

#!/bin/bash
#

# Replace next line with however you stop cyrus
# ie: killall master etc etc.
/etc/init.d/cyrus stop

mv /var/imap/mailboxes.db /var/imap/mailboxes.db.$$
cd /var/spool/imap/user
for i in `ls`
 do
  echo $i
  echo "user.$i<\t>default<\t>$i<\t>lrswipcda<\t>cyrus<\t>lrswipcda" >>
/tmp/newmboxlist.txt
 done

#
# Then when you have everyone's base directory in /tmp/newmboxlist.txt, do:
#

ctl_mboxlist -u </tmp/newmboxlist.txt

# and then:

cd /var/spool/imap/user
for i in `ls`
 do
  reconstruct -rf user.$i
 done


HTH
-Elmo