A simple small script for MySQL backup script

#!/bin/bash

#记录备份的时间
echo "-----" $ (date + "%y-%m-%d%h:%m:%s") "-----" >>/data/backup_mysql/record.log

#定义变量

Myuser=root
mypassword=29749716# @Heiniao
Socket=/data/mysql/mysql.sock
mycmd= "Mysql-u $MYUSER-p$mypassword-s $SOCKET"
mydump= "Mysqldump-u $MYUSER-p$mypassword-s $SOCKET"
Backupdir=/data/backup_mysql

#正式备份

For DB in ' $MYCMD-e ' show databases; "| Sed ' 1,2d ' | Egrep-v "Mysql|performance_schema"
Do
$MYDUMP $db > ${backupdir}/${db}_$ (Date +%f). sql
Done
CD ${backupdir}
Tar czvf ${backupdir}/$ (date +%f). tar.gz./*_$ (date +%f). sql
RM-RF ${backupdir}/*.sql
Find ${backupdir}-mtime +30-name "*.sql.tar.gz"-exec rm-rf {} \;

This article is from the "Campbell blog" blog, please be sure to keep this source http://jinbao.blog.51cto.com/6287622/1758419

A simple small script for MySQL backup script