How to implement full and incremental backup scripts in mysqldump

This article will explain in detail how to implement full and incremental backup scripts in mysqldump. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

#! / bin/bash

#

# mysql full backup script. It is recommended to run it on slave slave library and enable log_slave_updates=1.

Backupdir=/backup

DateDIR= `date +% Ymuri% mmury% d`

LogsindexPath=/usr/local/mysql/logs/ray-bin.index

If [!-d $backupdir]; then

Mkdir-p $backupdir

Fi

Cd ${backupdir}

If [!-d $dateDIR]; then

Mkdir-p $dateDIR

Fi

For i in `mysql-uroot-p123456-e "show databases" 2 > & 1 | grep-v-E "Database | Warning" `

Do

Mysqldump-uroot-p123456-- default-character-set=utf8-Q-- flush-privileges-- single-transaction-- master-data=1-- flush-logs-- routines-- triggers-- events-- hex-blob-E-R-B testdb | gzip > ${backupdir} / ${dateDIR} / mysql_back_$ {I} _ ${dateDIR} .sql.gz

Done

Binlog_rm= `tail-n 1 ${logsindexPath} | awk-F'/'{print $NF}'`

Mysql-uroot-p123456-e "purge binary logs to'${binlog_rm}'"

#! / bin/bash

# mysql incremental backup script, it is recommended to run it on slave slave server and enable log_slave_updates=1

Backupdir=/backup

DateDIR= `date +% Ymuri% mmury% d`

LogsIndexPath=/usr/local/mysql/logs/ray-bin.index

Mysqladmin-uroot-p123456 flush-logs

Binlog_cp= `head-n-1 ${logsIndexPath} `

For i in ${binlog_cp}

Do

Mysql-uroot-p123456-e "\! cp-p ${I} ${backupdir} / ${dateDIR} /"

Done

Binlog_rm= `tail-n 1 ${logsIndexPath} | awk-F'/'{print $NF}'`

Mysql-uroot-p123456-e "purge binary logs to'${binlog_rm}'"

This is the end of the article on "how to achieve full and incremental backup scripts for mysqldump". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.