Mysql Remote Backup and encoding script bitsCN.com
#! /Bin/bash
IP = 192.168.0.198
Mysqlpath =/usr/local/mysql/bin
Variables = '$ mysqlpath/mysql-u root-pmima-h $ IP-e "show variables like 'character/_ set/_ % '; "| awk '{print $2}' | sed-n '4' P'
$ Mysqlpath/mysqldump-uroot-pmima-h $ IP -- default-character-set = $ variables keyword_ad>/back/mysqldb/s198db/keyword_ad _ $ (date + % Y % m % d ). SQL;
$ Mysqlpath/mysqldump-uroot-pmima-h $ IP -- default-character-set = $ variables mysql>/back/mysqldb/s198db/s198mysql _ $ (date + % Y % m % d ). SQL;
Sleep 180 s
Cd/back/mysqldb/s198db/
/Bin/tar zcf keyword_ad _ $ (date 1_y1_m1_d1_.tar.gz keyword_ad _ $ (date + % Y % m % d). SQL
/Bin/tar zcf s198mysql _ $ (date using policy1_m1_d1_.tar.gz s198mysql _ $ (date + % Y % m % d). SQL
Sleep 60 s
/Usr/bin/find/back/mysqldb/s198db/-name "* .tar.gz"-mtime + 5-exec rm-rf {}/;
Sleep 60 s
/Usr/bin/find/back/mysqldb/s198db/-name "*. SQL"-mtime + 1-exec rm-rf {}/;
This article is from the blog "learning is everlasting ".
BitsCN.com