今天上班只有一台linux系统，就学着在linux上写了个脚本，没啥技术含量
省得每天敲代码备份
没有设置自动备份时间，这里可以参照
http://www.th7.cn/db/mysql/201305/30285.shtml
#!/bin/sh #powered by kangyxecho "get ready,starting backup now !"DUMP=/usr/bin/mysqldump #mysqldump备份程序执行路径 DATE=`date +%Y_%m_%d` #获取当前系统时间 OUT_DIR=/mysql_backup/daily/${DATE} #备份文件存放路径 LINUX_USER=root #系统用户名 DB_NAME=susliks_test #要备份的数据库名字DB_NAME2=koyoo_test DB_USER=root #数据库用户名 DB_PASS= #数据库密码 mkdir -p "$OUT_DIR"
# 创建目录echo "creating backup file directory "${OUT_DIR}" is ok!"echo "susliks_test first!" cd $OUT_DIR #进入备份存放目录 DB_NAME=susliks_testDB_NAME2=koyoo_test OUT_SQL="${DB_NAME}_${DATE}.sql"
#备份数据库的文件名 OUT_SQL2="${DB_NAME2}_${DATE}.sql" $DUMP -u$DB_USER -p$DB_PASS $DB_NAME> $OUT_SQL #备份 susliks_testecho "the backup of suslikes_test_${DATE} is finished"echo "starting koyoo_test now ^_^!"$DUMP -u$DB_USER -p$DB_PASS $DB_NAME2> $OUT_SQL2 #备份 susliks_test echo "the backup of koyoo_test_${DATE} is finished "echo "Have a good day! bye ^_^!" |
shell for mysql backup in linux
原文：http://www.cnblogs.com/kyxyes/p/3541682.html