My SQL热备份脚本

 #!/bin/bash

PATH=/usr/local/sbin:/usr/bin:/bin

 

#The directory of backup

BACKDIR=/usr/mysql_backup

#The password of mysql

ROOTPASS=password

 

#Remake the directory of backup

rm -rf $BACKDIR

mkdir -p $BACKDIR

 

#get the name of database

dblist='ls -p /var/lib/mysql | grep /

 |tr -d /'

 

#backup with database

for dbname in $DBLIST

do

mysqlhotcopy $dbname -u root -p

 $ROOTPASS $backdir | logger -t

mysqlhotcopy

done