周洋近况,吴玉珍,背脸打一成语
vim full_database_backup.sh #!/bin/sh path="/application/mysql/bin:$path" backup1=/backup1 backup2=/backup2 time=$(date +"%f:%h:%m:%s") user=root pass=12345 mysql="mysql -u$user -p$pass" mydump="mysqldump -u$user -p$pass -a -b -r --master-data=2 --single-transaction" if [ ! -d $backup1 -o ! -d $backup2 ];then mkdir $backup1 mkdir $backup2 $mydump |gzip >/$backup1/full_${time}.tar.gz cp $backup1/full_${time}.tar.gz $backup2 echo "您好,您的mysql数据已全库备份到${backup2}/full_${time}.tar.gz" else $mydump |gzip >/$backup1/full_${time}.tar.gz cp $backup1/full_${time}.tar.gz $backup2 echo "您好,您的mysql数据已全库备份到${backup2}/full_${time}.tar.gz" fi #生产环境:cp换成rsync再扔到crontab上定时运行
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复
linux下文本编辑器vim的使用方法(复制、粘贴、替换、行号、撤销、多文件操作)
网友评论