帮朋友写了意见简单的!
关于mysql svn备份方式有很多种,这里就写一个基于文件系统的,至于mysql repication,或者rsync 或者svn自带的备份,就不细表了!
- #!/bin/bash
- cd /backup
- if
- [ ! -f /backup/logfile ]
- then touch logfile
- fi
- mysqldump -uroot -pnewbie bugfree2 > bugfree2-`date +%Y-%m%d`.sql
- tar -czf svn-`date +%Y-%m%d`.tar.gz /svn
- OLDSVN=$"svn-`date +%Y-%m%d --date='7 days ago'`.tar.gz"
- OLDSQL=$"bugfree2-`date +%Y-%m%d --date='7 days ago'`.sql"
- if
- [ -f $OLDSVN ]
- then rm -rf $OLDSVN >> logfile 2>&1
- echo "$OLDSVN delete old svnbak success" >> logfile
- else
- echo "$OLDSVN no old backup file" >> logfile
- fi
- if
- [ -f $OLDSQL ]
- then rm -rf $OLDSQL >> logfile 2>&1
- echo "$OLDSQL delete old svnbak success" >> logfile
- else
- echo "$OLDSQL no old backup file" >> logfile
- fi
- ~
- ~
- ~
- ~
转载于:https://blog.51cto.com/fghjk/903849