MySQL database remote backup data preferably packed and compressed
[Email protected] crontab]# pwd
/data/mysql_bakup/crontab
[email protected] crontab]# cat backup_db_wangshibo.sh
#!/bin/bash
Mysql= "/usr/bin/mysql"
mysqldump= "/usr/bin/mysqldump"
Backup_dir= "/data/mysql_bakup"
#DB_SOCKET = "/var/lib/mysql/mysql.sock"
Db_hostname= "110.120.11.9"
Dbname= "Wangshibo"
Db_user= "Db_wangshibo"
Db_pass= "Mhxzk3rfzh"
Time= ' Date +%y%m%d%h%m%s '
Lock_file= "${backup_dir}/lock_file.tmp"
Bkup_log= "/data/mysql_backup/${time}_bkup.log"
del_bak= ' date-d ' days ago ' +%y%m%d '
# #To Judge Lock_file
if [[-F $LOCK _file]];then
Exit 255
Else
echo $$ > $LOCK _file
Fi
# #dump databases##
Echo ${time} >> ${bkup_log}
echo "=======start bakup============" >>${bkup_log}
#${mysqldump}-H ${db_hostname}-u${db_user}-p${db_pass}--databases ${dbname} | gzip-9 > ${backup_dir}/${time}.${dbname}.gz
${mysqldump}-H ${db_hostname}-u${db_user}-p${db_pass}--databases ${dbname} |gzip-9 > ${backup_dir}/${time}.${ Dbname}.gz
echo "=======finished bakup============" >>${bkup_log}
/bin/rm-f ${lock_file}
# #del back ten days before##
/bin/rm-f ${backup_dir}/${del_bak}*.gz
Scheduled backups
[Email protected] mysql_bakup]# crontab-l
Ten 0,6,12,18 * * */bin/bash/data/mysql_bakup/crontab/backup_db_wangshibo.sh >/dev/null 2>&1
[Email protected] crontab]# Cd/data/mysql_bakup
[[email protected] mysql_bakup]# ls
20161202061001.wangshibo.gz
A scheduled backup script on MySQL line