Sqlite db repair script

repairsqlite.sh

#!/bin/bash

DBSTATUS=$(sqlite3 "$1" "PRAGMA integrity_check")
if [ "$DBSTATUS" == "ok" ] ; then
    echo DB ALREADY OK
else
    echo FIXING CORRUPT DB
    TMPDB=$(mktemp -t sarim)
    echo ".mode insert
.dump" | sqlite3 "$1" > $TMPDB
    rm "$1"
    sed -i "" "s/ROLLBACK; -- due to errors/COMMIT;/" $TMPDB
    sqlite3 "$1" < $TMPDB
    rm $TMPDB
    echo DB FIXED
fi

throwing really a lot of errors (multiline command isn't normal, /tmp can be full, sed should not have two expressions..), using this:

[ "$1" == "" ] && exit
DBSTATUS=$(sqlite3 "$1" "PRAGMA integrity_check")
if [ "$DBSTATUS" == "ok" ] ; then
    echo "DB ALREADY OK"
else
    echo "FIXING CORRUPT DB (status $DBSTATUS)"
    TMPDB=$1.tmp
    echo -e ".mode insert\n.dump" | sqlite3 "$1" > $TMPDB
    rm "$1"
    sed -i  "s/ROLLBACK; -- due to errors/COMMIT;/" $TMPDB
    sqlite3 "$1" < $TMPDB
    rm $TMPDB
    echo "DB FIXED"
fi