MySQL backup script

#!/bin/sh

Dump=/usr/local/mysql/bin/mysqldump

Out_dir=/data01/mysqldata_bak

Linux_user=bakmysql

Db_name= database name

db_user= User Name

db_pass= Password

Days=7

CD $OUT _dir

Date= ' Date +%y_%m_%d '

Out_sql= "$DATE. SQL"

Tar_sql= "Mysql_bak_$date.tar.gz"

$DUMP-u$db_user-p$db_pass $DB _name--default-character-set=utf8--opt-q-R--skip-lock-tables> $OUT _sql

TAR-CZF $TAR _sql./$OUT _sql

RM $OUT _sql

Chown $LINUX _user: $LINUX _user $OUT _dir/$TAR _sql

Find $OUT _dir-name "mysql_bak*"-type f-mtime + $DAYS-exec rm {} \;

This article is from the "System operation and maintenance website Development" blog, please be sure to keep this source http://cgc888.blog.51cto.com/3989433/1688325

MySQL backup script