-
mysql linux 备份脚本
- #!/bin/sh
- # mysql data backup script
- #
- # use mysqldump --help,get more detail.
- #
- BakDir=/root/back/mysql
- LogFile=/root/back/mysql/mysqlbak.log
- DATE=`date +%Y%m%d%H%M%S`
- echo " " >> $LogFile
- echo " " >> $LogFile
- echo "-------------------------------------------" >> $LogFile
- echo $(date +"%y-%m-%d %H:%M:%S") >> $LogFile
- echo "--------------------------" >> $LogFile
- cd $BakDir
- DumpFile=$DATE.sql
- GZDumpFile=$DATE.sql.tar.gz
- /usr/local/bin/mysqldump -u user -pname --database -h 127.0.0.1 db> $DumpFile
- echo "Dump Done" >> $LogFile
- tar czvf $GZDumpFile $DumpFile >> $LogFile 2>&1
- echo "[$GZDumpFile]Backup Success!" >> $LogFile
- rm -f $DumpFile
- #cd $BakDir/daily
- cd $BakDir
- echo "Backup Done!"
- echo "please Check $BakDir Directory!"
- echo "copy it to your local disk or ftp to somewhere !!!"
- find $BakDir -ctime +30 -exec rm {} ;
- echo "delete file over 30 days"
-
相关阅读:
Centos7安装redis
Cookie和Session的区别
JavaWeb中的域对象
ServletContext使用介绍
Java Web核心组件之Servlet的使用介绍
关于反射的杂谈
leetcode117search-in-rotated-sorted-array
23longest-consecutive-sequence
leetcode24:word-ladder-ii
leetcode25word-ladder
-
原文地址:https://www.cnblogs.com/taoboy/p/4798694.html
Copyright © 2020-2023
润新知