mysql backup script
来源:互联网 发布:cf老是网络出现异常23 编辑:程序博客网 时间:2024/05/21 19:38
#!/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 {} \;
# 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"
其中user,name和db请根据自己的情况修改
- MySQL-mysqldump backup script
- mysql backup script
- mysql backup script
- Shell Script For MySQL Enterprise Backup Crontab Schedule
- oracle backup script
- Powershell Database Backup Script
- simple auto backup ftp script
- oracle auto backup shell script
- 脚本-create dd backup script
- MySQL backup & restore
- MySQL Compressed Backup
- MySQL Backup and Restore
- [shell]mysql backup脚本
- Easy shell script to Backup the whole folder
- VMware ESX 3.0 VM Backup script by Tooms
- [转]VMware ESX 3.0 VM Backup script by Tooms
- MySQL Database backup and restore
- Shell-Check MySQL Backup Status
- CPUID——检测CUP信息及程序的实现
- UVA 11987 Almost Union-Find(并查集)
- uva 10420 - List of Conquests
- android 不让edittext自动获取焦点
- UML中的六大关系
- mysql backup script
- LigerUi中的Grid中不分页显示(local)!
- vsftp 常见错误
- linux下一般程序运行时查找动态库的顺序
- Android权限的理解
- ListView中几个特殊属性
- hdu4639(排列组合)
- 找到字符串中出现次数最多的那个字符
- 汉诺塔(递归法)