#!/bin/bash based=/var/backup_dir pass=secret function usage() { echo "Usage: `basename $0` [-db <database>|-list|-pull <host>|-commit]*" if [[ -n "$1" ]]; then echo "Unknown parameter $1 " fi exit $E_BADARGS } function listdbs() { echo "SHOW DATABASES;" | mysql -uroot -p$pass } function dumpDaten() { install -g mysql -o mysql -d $based/$db mysqldump -uroot -p$pass -f --skip-comments --single-transaction -T $based/$db $db cd $based/$db hg addremove -s 70 } function commit() { cd $based hg commit -m "backup $(date '+%Y%m%d %H:%M')" 2> /dev/null } function pull() { cd $based hg pull https://$host/$based } # --- main VERBOSE=1 if [[ "$1" == "-q" ]]; then VERBOSE=0 shift fi if [[ ! -n "$1" ]]; then usage fi while [ "x$1" != "x" ] do case $1 in "-list") listdbs ;; "-db") db=$2; shift ; dumpDaten ;; "-pull") host=$2; shift ; pull ;; "-commit") commit ;; *) usage $1 ;; esac shift done #vim:set ts=4
mysql_dump --ignore-table=db_name.tbl_name
hg -X cache