#!/bin/bash
export Today="`date '+%y-%m-%d'`"
backup_count="7" #### 백업본 보관 일 수 (7일간 보관)
############################ mysql_backup ###########################
backup_dir="/backup/mysql_oh_yea"
## 오래된 데이터 삭제
dirlists=`/bin/ls -t $backup_dir 2>/dev/null`
i=1
for dir in $dirlists ; do
if [ "$i" -ge $backup_count ] ; then
/bin/rm -rf "$backup_dir/$dir"
fi
i=$(($i+1))
done
## create directory
/bin/mkdir -p ${backup_dir}/$Today
cd ${backup_dir}/$Today
## DB백업
db_root_pw="*****" <== db root password 를 입력한다.
db_list=`echo "show databases;" | mysql -N -uroot -p"$db_root_pw"`
## DB별로 백업
for db in $db_list ; do
mysqldump -uroot -p"$db_root_pw" $db > $db.sql
done
# TABLE 단위로 백업
#for db in $db_list ; do
# table_list=`echo "show tables" | mysql -N -uroot -p"$db_root_pw" $db`
# for table in $table_list ; do
# mysqldump -uroot -p"$db_root_pw" $db $table > $db.${table}.sql
# done
#done
|
