rebuild-database

rebuild-database (text/plain), 1.41 KB, created by Maurice Müller on 2004-08-29 19:33:24 UTC

#!/bin/sh
# Adapted http://l13.de/linux/inn.html for our needs
# This turned out as very useful in case INN crashes.

echo 'This will rebuild the overview and history database.'
echo 'Please be patient as this can consume a lot of time.'
echo 'So it is perhaps a good idea to go out or drink a tea awhile.'
echo ''
echo 'Shutting down the server...'
/etc/init.d/innd stop
echo 'Deleting the old overview database...'
rm -R /var/spool/news/overview
echo 'Creating the new overview database...'
mkdir /var/spool/news/overview
echo 'Deleting the old history database...'
rm /var/spool/news/db/history
rm /var/spool/news/db/history.*
echo 'Creating a new history database...'
cd /var/spool/news/db
touch history
chown news:news history
/usr/lib/news/bin/makedbz -f history -i
echo 'Populating the new history database (may take a _long_ time...)'
chown news:news *
/usr/lib/news/bin/makehistory -b
chown news:news *
/usr/lib/news/bin/makedbz -f history -i
chown news:news * /var/spool/news/overview
echo 'Populating the new overview database (may take a long time...)'
/usr/lib/news/bin/makehistory -O -x
echo 'Chown all files to user news and group news.'
chown news:news * ../* ../overview/*
echo 'Now starting the server again...'
/etc/init.d/innd start
echo 'We will renumber all articles...'
su - news -c 'for NEWSGROUP in `cat /var/spool/news/db/active | cut -f 1 -d " "`; do /usr/lib/news/bin/ctlinnd renumber $NEWSGROUP; done'
echo 'Finished.'