#!bin/bash
Host=47.93.191.79
Port=3306
mysqlfoo(){
	mysqldump -h$Host -P$Port -u$1 -p$2 -d $3 > backup-$4.sql
	mysqldump -h$Host -P$Port -u$1 -p$2 -t $3 > backup-$4-data.sql
	echo $4 'end'
}
cd H:/mysqlbak
mv backup* H:/mysqlbak/oldbackup
Now=$(date +"%Y-%m-%d-%H-%M-%S")
mysqlfoo wp_lmyperson_co CM7yEmHCXr wp_lmyperson_co $Now-wp
mysqlfoo blog_lmyperson_ DGtBj8aECw blog_lmyperson_ $Now-blog
mysqlfoo www_lmyperson_c KWeeGPNcPc www_lmyperson_c $Now-www
mysqlfoo link_lmyperson_ XRKQEEXxWD link_lmyperson_ $Now-link
mysqlfoo cos_lmyperson_c twS3ATikBf cos_lmyperson_c $Now-cos
mysqlfoo www z2GYzDtGyc www $Now-wwwwww
mysqlfoo the_lmyperson_c SAmjXTr2Nd the_lmyperson_c $Now-the
mysqlfoo api_lmyperson_c mPZfPyyHBB api_lmyperson_c $Now-api
mysqlfoo wb_lmyperson_co HRER8EHxJR wb_lmyperson_co $Now-wb
mysqlfoo dwz_lmyperson_c 5FAnKz5ZZn dwz_lmyperson_c $Now-dwz
mysqlfoo piwik_lmyperson xf4txE73Sd piwik_lmyperson $Now-piwik
mysqlfoo layer_lmyperson_ 2mkr8E5TNc layer_lmyperson_ $Now-layer
mysqlfoo laravel s4NhPxfk3w laravel $Now-laravel
mysqlfoo xiao lmy19930106 xiao $Now-xiao
mysqlfoo yii_lmyperson_c G6riBYycxh yii_lmyperson_c $Now-yii
mysqlfoo fast_lmyperson_ cHfjhdEEkj fast_lmyperson_ $Now-fast
mysqlfoo capture_data EHMR74cZmS capture_data $Now-capture
mysqlfoo zjy 6knjRjk3Bp zjy $Now-zjy
mysqlfoo pub_lmyperson_c yyy5exxaDt pub_lmyperson_c $Now-pub
mysqlfoo ishop 12345678 ishop $Now-ishop
mysqlfoo laravel_learn WwNEZWfWnt laravel_learn $Now-laravel-learn
mysqlfoo nlkjchandao CBcFfa5j44 nlkjchandao $Now-nlkjchandao
mysqlfoo zhaopin_lmypers FXFz4SBnGF zhaopin_lmypers $Now-zhaopin