Skip to content

Instantly share code, notes, and snippets.

@dedeibel
Created May 15, 2016 10:45
Show Gist options
  • Save dedeibel/9cdf3b844a211f823d65bc515117c75c to your computer and use it in GitHub Desktop.
Save dedeibel/9cdf3b844a211f823d65bc515117c75c to your computer and use it in GitHub Desktop.
seafile sqlite db backup skript
#!/bin/bash
set -e
BASEDIR=/opt/seafile/mysite
OUTDIR=${BASEDIR}/backup/db
mkdir -p ${OUTDIR}
SUFFIX=.`date +"%Y-%m-%d-%H-%M-%S"`
sqlite3 ${BASEDIR}/ccnet/GroupMgr/groupmgr.db .dump | gzip > ${OUTDIR}/groupmgr.db.bak${SUFFIX}.gz
sqlite3 ${BASEDIR}/ccnet/PeerMgr/usermgr.db .dump | gzip > ${OUTDIR}/usermgr.db.bak${SUFFIX}.gz
sqlite3 ${BASEDIR}/seafile-data/seafile.db .dump | gzip > ${OUTDIR}/seafile.db.bak${SUFFIX}.gz
sqlite3 ${BASEDIR}/seahub.db .dump | gzip > ${OUTDIR}/seahub.db.bak${SUFFIX}.gz
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment