build database cleanup from configure to have it behaving a bit closer to the install...

[citadel.git] / citadel / database_cleanup.sh.in

diff --git a/citadel/database_cleanup.sh.in b/citadel/database_cleanup.sh.in
new file mode 100755 (executable)
index 0000000..fa5c3cf
--- /dev/null
+++ b/citadel/database_cleanup.sh.in
@@ -0,0 +1,119 @@
+#!/bin/bash
+
+die () {
+       echo Exiting.
+       exit 1
+}
+
+# data dir from autoconf?
+DATA_DIR="@MAKE_DATA_DIR@"
+if test -z "$DATA_DIR" ; then
+       DATA_DIR="/usr/local/citadel"
+fi
+DATA_DIR=$DATA_DIR/data
+
+# If we're on an Easy Install system, use our own db_ tools.
+#
+if [ -x /usr/local/ctdlsupport/bin/db_dump ] ; then
+       export PATH=/usr/local/ctdlsupport/bin:$PATH
+       RECOVER=/usr/local/ctdlsupport/bin/db_recover
+       DUMP=/usr/local/ctdlsupport/bin/db_dump
+       LOAD=/usr/local/ctdlsupport/bin/db_load
+
+else
+       # ok usual install?
+       if test -f /usr/bin/db_dump; then 
+               RECOVER=/usr/bin/db_recover
+               DUMP=/usr/bin/db_dump
+               LOAD=/usr/bin/db_load
+       else
+               if test -n "`ls /usr/bin/db?*recover`"; then
+                       # seems we have something debian alike thats adding version in the filename
+                       if test "`ls /usr/bin/db*recover |wc -l`" -gt "1"; then 
+                               echo "Warning, you have more than one berkley db utility version installed. using the latest one." 1>&2
+                               RECOVER=`ls /usr/bin/db*recover |sort |tail -n 1`
+                               DUMP=`ls /usr/bin/db*dump |sort |tail -n 1`
+                               LOAD=`ls /usr/bin/db*load |sort |tail -n 1`
+                       fi
+               else
+                       echo "We can't find the berkeley DB tools, exiting." 1>&2
+                       die
+               fi
+
+       fi
+fi
+
+# Ok, let's begin.
+#
+
+clear
+cat <<!
+
+Citadel Database Cleanup
+---------------------------
+
+This script exports, deletes, and re-imports your database.  If you have
+any data corruption issues, this program may be able to clean them up for you.
+ 
+Please note that this program does a Berkeley DB dump/load, not a Citadel
+export.  The export files are not generated by the Citadel export module.
+
+WARNING #1:
+  MAKE A BACKUP OF YOUR DATA BEFORE ATTEMPTING THIS.  There is no guarantee
+  that this will work (in case of disk full, power failure, program crash)!
+
+WARNING #2:
+  citserver must NOT be running while you do this.
+
+WARNING #3:
+  Please try "cd $DATA_DIR; $RECOVER -c" first.  Use this tool
+  only if that one fails to fix your problem.
+
+WARNING #4:
+  You must have an amount of free space on your disk that is at least twice
+  the size of your database, see the following output:
+  (for substantial better performance you should specify a location that's 
+   on another disk than $DATA_DIR)
+
+`df -h`
+
+you will need `du -sh $DATA_DIR|sed "s;/.*;;"` of free space.
+
+!
+
+echo -n "Do you want to continue? "
+
+read yesno
+case "$yesno" in
+       "y" | "Y" | "yes" | "YES" | "Yes" )
+               echo 
+               echo DO NOT INTERRUPT THIS PROCESS.
+               echo
+       ;;
+       * )
+               exit
+esac
+
+for x in 00 01 02 03 04 05 06 07 08 09 0a
+do
+       filename=cdb.$x
+       echo Dumping $filename
+       $DUMP -h $DATA_DIR $filename >/tmp/CitaDump.$x || die
+       rm -f $DATA_DIR/$filename
+done
+
+echo Removing old databases
+rm -f ./data/*
+
+for x in 00 01 02 03 04 05 06 07 08 09 0a
+do
+       filename=cdb.$x
+       echo Loading $filename
+       $LOAD -h $DATA_DIR $filename </tmp/CitaDump.$x && {
+               rm -f /tmp/CitaDump.$x
+       }
+done
+
+echo 
+echo Dump/load operation complete.  Start your Citadel server now.
+echo