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