mysql备份脚本（待续）

#!/bin/bash


#configuration

db_user="root"
db_password=""
db_host="127.0.0.1"
db_port="3306"
db_name="crashcourse"
db_backup_dir="/home/db_backup/"
db_recyle_dir="/home/db_recyle/"
time_now=` date '+%Y%B%d%H%M%S' `
db_backup_name="$db_name""$time_now"
nbackup=3
expired=30
nmv=0


#start

#backup

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

#mv

cd $db_backup_dir
nbackup_now=`ls -l "$db_name"*|wc -l`
if [[ $nbackup_now -gt $nbackup ]]
then
        nmv=$(( nbackup_now - nbackup ))
fi
mv_name=`ls -ltr "$db_name"* |head -n $nmv|awk '{print $8}'`
for imv_name in $mv_name
do
        mv "$imv_name" "$db_recyle_dir"
done