MySQL backup script

#!/bin/sh

################################################

#this scripts is created by Tangbo

#tangbo qq:79313760

################################################

#parameter defined Start

Bakdate= ' Date +%f '

Myuser=root

Mypass= "111111"

Mysock=/data/3306/mysql.sock

Dbname= "Caiwu"

Main_path=/server/backup

Data_path=/server/backup

Log_file=${data_path}/mysql_logs_${bakdate}.log

Data_file=${data_path}/mysql_backup_${bakdate}.sql.gz

#command defined

Mysql_path=/usr/local/mysql/bin

#MYSQL_DUMP = "$MYSQL _path/mysqldump-u$myuser-p$mypass-s $MYSOCK-A-b-f--single-transaction-e"

mysql_dump= "$MYSQL _path/mysqldump-u$myuser-p$mypass-s $MYSOCK-F-B $DBNAME--DEFAULT-CHARACTER-SET=GBK-- Single-transaction-e "

#backup command

${mysql_dump} | gzip > $DATA _file

#check Backup Result

Du-sh $DATA _file > $LOG _file

Mail-s "${bakdate} mysql bak log" [email protected] < $LOG _file

################# #end ##########################

This article from "Bobcat" blog, declined reprint!

MySQL backup script