#!/bin/bash
SERVER=root@a.datux.nl
SPAMUSER=psy

echo "Dumping spamdatabase from $SERVER, user $SPAMUSER..."
ssh $SERVER "dspam_2sql $SPAMUSER" > dump.sql || exit 1

rm global.sql* 2>/dev/null

echo "begin;" >> global.sql
echo "delete from dspam_preferences where uid=1;" >> global.sql
echo "delete from dspam_signature_data where uid=1;" >> global.sql
echo "delete from dspam_stats where uid=1;" >> global.sql
echo "delete from dspam_token_data where uid=1;" >> global.sql

sed 's/values([0-9]*,/values(1,/' dump.sql >> global.sql 

echo "commit;" >> global.sql

gzip global.sql


rm dump.sql

echo "Ok done, global.sql.gz is updated with filter of $SPAMUSER from server $SERVER !"