mysql完全备份

#!/bin/bash



#configuration


db_user="root"
db_password="123456"
db_host="10.10.11.151"
db_port="3306"
db_name="crashcourse"
db_backup_dir="/dir/full_backup/"
db_recyle_dir="/dir/full_recyle/"
time_now=` date '+%Y%B%d%H%M%S' `
db_backup_name="$db_name""$time_now"
nbackup=3


#start


#backup

echo "Begin fullbackup"
mysqldump -h"$db_host" -P"$db_port" -u"$db_user" -p"$db_password" -lF --opt $db_name > "$db_backup_dir""$db_backup_name"

#mv


cd $db_backup_dir
not_mv_name=`ls -ltr ${db_name}* |tail -n${nbackup}|awk '{print $8}'`
all_name=`ls -ltr ${db_name}*|awk '{print $8}'`
for i in ${all_name[@]}
do
        need_mv=1
        for j in ${not_mv_name[@]}
        do

                if [ $i = $j ]
                then
                        need_mv=0
                fi
        done
        if [ $need_mv -eq 1 ]
        then
                mv $i "$db_recyle_dir"
        fi
done


echo "done"