#!/bin/bash DB_USER=root DB_PASSWD="" #需要备份的数据库名 DATABASES="bigamer bigamer_ucenter bigamer_anwsion bigamer_passport" BACKUP_DIR="/home/backup/mysql/" DATE=`date '+%Y%m%d'` DUMPFILE=$DATE.sql ARCHIVEFILE=$DUMPFILE.tar.gz DUMP_ARGS="-u $DB_USER -p $DB_PASSWD --add-drop-table --add-drop-database -B $DATABASES" DUMP_BIN=`which mysqldump` if [ ! -d $BACKUP_DIR ]; then mkdir -p "$BACKUP_DIR" fi cd $BACKUP_DIR $DUMP_BIN $DUMP_ARGS > $DUMPFILE if [[ $? == 0 ]]; then tar czf $ARCHIVEFILE $DUMPFILE rm -f $DUMPFILE fi #清理五天前备份的数据 find $BACKUP_DIR -name "*.sql.tar.gz" -type f -mtime +5 -exec rm {} \; > /dev/null 2>&1 echo "Backup Process Done"
Category Archives: debian
定时备份mysql数据
Posted by wolftankk
on 2012/06/26
No comments
Debina6 升级安装python2.7
Posted by wolftankk
on 2012/01/13
No comments
只要在/etc/apt/source.list中加入
deb http://ftp.cn.debian.org/debian/ unstable main contrib non-free
apt-get clean
apt-get update
然后就可以安装python2.7 vim7.3这些最新的软件了
使用debian做路由网关
Posted by wolftankk
on 2011/10/18
2 comments
必要软件
今天利用debian做了一台路由网关, 并且能自动翻墙.
首先你需要一些东西: 一台已架设好openvpn/vpn的服务器, 一个已安装好debian系统的电脑或者虚拟机.
首先进入debian, 安装一些必要的软件
apt-get install openssl curl openvpn iptables bind9