Home Database Mysql Tutorial MySQL异地增量备份

MySQL异地增量备份

Jun 07, 2016 pm 05:59 PM
mysql backup

MySQL异地增量备份: 1.#!/bin/sh 2. 3.#MySQL Info 4.sqluser=root 5.sqlpsw=root 6. 7./usr/bin/mysqladmin -u$sqluser -p$sqlpsw flush-logs --default-character-set=GBK 8. 9.DATADIR=/data/mysql 10.BAKDIR=/home/backup/mysql/daily 11.TEMPDIR=/home/b

MySQL异地增量备份:

1.#!/bin/sh 
2.
3.#MySQL Info  
4.sqluser=root  
5.sqlpsw=root  
6. 
7./usr/bin/mysqladmin -u$sqluser -p$sqlpsw flush-logs --default-character-set=GBK   8. 
9.DATADIR=/data/mysql  
10.BAKDIR=/home/backup/mysql/daily  
11.TEMPDIR=/home/backup/mysql/temp  
12. 
13.BINLOGNAME='mysql-bin'  14.cd $DATADIR  
15.FILELIST=$(cat $BINLOGNAME.index | cut -c3-)  16.
17.## COUNTER number  
18.COUNTER=0  
19.for file in $FILELIST   20.do  21.COUNTER=$(expr $COUNTER + 1)  
22.done  
23. 
24.NextNum=0  
25.for file in $FILELIST   26.do  27.NextNum=$(expr $NextNum + 1)  
28.if test "$NextNum" = "$COUNTER"  29.then  
30.echo "skip lastest"  31.else  32.dest=$BAKDIR/$file  
33.if test -e $dest   34.then  
35.echo "skip exist $dest"  36.else  37.cp $file $TEMPDIR  
38.fi  
39.fi  
40.done  
41.echo "backup mysql binlog ok"  42. 
43.sleep 2s  
44. 
45.cd $TEMPDIR  
46.tarname=binlog$(date +%y%m%d).tar.gz  
47.tar czf $tarname ./mysql-bin*  
48. 
49.sleep 1s  50.
51.#ftp Info  
52.ftphost=111.111.11.11  
53.ftpname=xxx  
54.ftppsw=psw  
55. 
56.cd $TEMPDIR  
57. 
58.ftp -i -n 59.open $ftphost  
60.user $ftpname $ftppsw  
61.type binary  
62.put $tarname  
63.close  
64.bye  
65.!  
66.sleep 10s  
67. 
68.echo "end upload"  69. 
70.cd $TEMPDIR  
71.mv $BINLOGNAME* $BAKDIR  
72.rm -r $tarname  
73. 
74.echo "end"  说明:

mysqladmin -u$sqluser -p$sqlpsw flush-logs:mysql自动把内存中的日志放到日志文件binlog的最后一个文件里,并生成一个空的新日志文件,之后只需要备份前面的几个即可,最后一个因为是刚生成的,并且是空的,所以不需备份。

关于binlog可参考: http://www.linuxidc.com/Linux/2012-09/70815.htm

大概思路:

把datadir和bakdir目录中的binlog进行对比,如bakdir中没有,且该binlog不是最后一个,则把该binlog复制到tempdir中;这样tempdir中的binlog都是新增的binlog。之后把tempdir中的binlog进行打包压缩,ftp到另一个服务器上。
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP's big data structure processing skills PHP's big data structure processing skills May 08, 2024 am 10:24 AM

PHP's big data structure processing skills

How to optimize MySQL query performance in PHP? How to optimize MySQL query performance in PHP? Jun 03, 2024 pm 08:11 PM

How to optimize MySQL query performance in PHP?

How to use MySQL backup and restore in PHP? How to use MySQL backup and restore in PHP? Jun 03, 2024 pm 12:19 PM

How to use MySQL backup and restore in PHP?

What are the application scenarios of Java enumeration types in databases? What are the application scenarios of Java enumeration types in databases? May 05, 2024 am 09:06 AM

What are the application scenarios of Java enumeration types in databases?

How to insert data into a MySQL table using PHP? How to insert data into a MySQL table using PHP? Jun 02, 2024 pm 02:26 PM

How to insert data into a MySQL table using PHP?

How to fix mysql_native_password not loaded errors on MySQL 8.4 How to fix mysql_native_password not loaded errors on MySQL 8.4 Dec 09, 2024 am 11:42 AM

How to fix mysql_native_password not loaded errors on MySQL 8.4

How to use MySQL stored procedures in PHP? How to use MySQL stored procedures in PHP? Jun 02, 2024 pm 02:13 PM

How to use MySQL stored procedures in PHP?

Performance optimization strategies for PHP array paging Performance optimization strategies for PHP array paging May 02, 2024 am 09:27 AM

Performance optimization strategies for PHP array paging

See all articles