|
#!/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"
|
