맘대로 DIY

무결성 보장 : single-transaction
한글지원 : default-character-set=utf8

#!/bin/sh

## yyyymmdd_hhmm format
DATE=$(date "+%Y%m%d")
TIME=$(date "+%Y%m%d_%H%M")
PATH="/home/woohaeng/MyDisk/Backup/MySql"
PATHTIME=${PATH}/${DATE}/${TIME}

#/bin/mv ${PATH}*.sql "/media/vf-db/Seagate Backup Plus Drive/DB백업"

cd ${PATH}
/bin/mkdir ${DATE}

/usr/bin/mysqldump --single-transaction --databases qhedge_dev_daily -h localhost -u root -p*** --default-character-set=utf8 > ${PATHTIME}_qhedge_dev_daily.sql
/usr/bin/mysqldump --single-transaction --databases vf_pattern -h localhost -u root -p*** --default-character-set=utf8 > ${PATHTIME}_vf_pattern.sql
/usr/bin/mysqldump --single-transaction --databases vf_stockdb -h localhost -u root -p*** --default-character-set=utf8 > ${PATHTIME}_vf_stockdb.sql

zip ${PATH}/${DATE}.zip ${PATH}/${DATE}/*


>> 복구
mysql -u root -p < vf_stockdb_us.sql