Sqlite db repair script
#!/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 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment