#!/bin/bash #by azura #About database backup #URL https://www.mxsina.com DBCMD=/usr/local/mysql/bin/mysqldump #请修改为数据库dump命令目录 DBUSER=root DBPWD=123456789 #数字段请修改为root用户数据库连接密码 DATABASE=emlogdb #emlogdb请修改为备份的数据库 BAK_DIR=/mysqlbak/`date +%Y%m%d` #/mysqlbak/目录可自由修改 if [ ! -d $BAK_DIR ];then mkdir -p $BAK_DIR fi if [ $UID -ne 0 ];then echo"Please use the root user to execute" exit fi echo "-------------------------------------------------------------------------------------------------" echo echo "Start the database backup" #示例备份命令mysqldump -uroot -p123456789 emlogdb > /mysqlbak/bak_emlogdb.sql $DBCMD -u$DBUSER -p$DBPWD $DATABASE > $BAK_DIR/db_emlog.sql #db_emlog.sql可修改为备份文件的文件名 if [ $? -eq 0 ];then echo -e "\033[32mBackup Success !\033[0m" else echo "Backup Fail" fi find $BAK_DIR -mtime +30 -exec rm -rf {} \; #此处数字可修改表示删除30前的数据 #蔚然博客Azura编写
本文作者为SKY RING,转载请注明。