#! /bin/sh

# Back up the database.

# Copy to an alternate file, and drop the lesson data, as that is more
# transient.
cp learn.db backup.db
sqlite3 backup.db <<Z
DELETE FROM lesson;
DELETE FROM list;
Z

sqlite3 backup.db .dump > learn-$(date +%Y-%m-%d-%H%M).sql
rm backup.db