restore_sqlite_db.sh
· 196 B · Bash
Raw
#!/bin/bash
# Usage: `restore_sqlite_db.sh db.sqlite3`
# See https://stackoverflow.com/a/15874884/3645337.
cat <( sqlite3 "$1" .dump | grep "^ROLLBACK" -v ) <( echo "COMMIT;" ) | sqlite3 "fix_$1"
| 1 | #!/bin/bash |
| 2 | # Usage: `restore_sqlite_db.sh db.sqlite3` |
| 3 | # See https://stackoverflow.com/a/15874884/3645337. |
| 4 | cat <( sqlite3 "$1" .dump | grep "^ROLLBACK" -v ) <( echo "COMMIT;" ) | sqlite3 "fix_$1" |
| 5 |