本篇内容介绍了“mysql的备份脚本分享”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！
#!/bin/bash
#################################################################
# #
# Purpose: MySQL backups #
# This script does a full or incremental backup #
# The full is done via mysqldump#
# The incremental is done via flush-logs option #
# with mysqladmin#
# #
# The script is also setup to email if a #
# failure occurs #
# #
# Assumptions: #
# 1. Database is in Binary Update Log mode #
# 2. The variables are set correctly #
##
#Usage:mysql_backup [full|incremental]#
##
# #
#################################################################
#################################################################
# INITILIAZE VARIABLES #
#################################################################
# Set the mode, full|incremental
# parameter is passed in
MODE=$1
# set the username to connect to mysql for the backup
MYSQLUSER=backup
# set the password to connect to mysql for the backup
MYSQLUSERPW=password
# set the Binary Update Logs Path
BINLOGPATH=/mysql/logs/emds01/mysql
# Set the binary Update Logs name
BINLOGNAME=viper2-bin
# set the backup path
BACKUPPATH=/export/home/mysql/backups
# set the email address for errors to be emailed to
EMAIL_ADDR=shenandoah.speers@cicadacorp.com
# set the log file
LOGFILE=$BACKUPPATH/logs/$HOSTNAME_$RUNDATE.log
# set the error log file
LOGERR=$BACKUPPATH/logs/ERRORS_$HOSTNAME_$RUNDATE.log
# set the number of days to keep the backups
DAYSTOKEEP=5
# set Run date
RUNDATE=`date +%Y%m%d%s`
# set hostname
HOSTNAME=`uname -n`
#################################################################
# GLOBAL FUNCTIONS #
#################################################################
copyBinlogs() {
# copy binlogs to backup dir
echo "Copying binlogs"
for FILE in `cat $BINLOGPATH/$BINLOGNAME.index`
do
SFILE=(${FILE/*/
由 dawei
【声明】：南充站长网内容转载自互联网，其相关言论仅代表作者个人观点绝非权威，不代表本站立场。如您发现内容存在版权问题，请提交相关链接至邮箱：bqsm@foxmail.com，我们将及时予以处理。