MySQL的热备份脚本
1089
- riskstar2011-01-11金牌会员11033
这是MySQL的备份方式之一,脚本如下:
- #!/bin/bash
- PATH=/usr/local/sbin:/usr/bin:/bin
- - # The Directory of Backup
- BACKDIR=/usr/mysql_backup
- # The Password of MySQL
- ROOTPASS=password
- - # Remake the Directory of Backup
- rm -rf $BACKDIR
- mkdir -p $BACKDIR
- - # Get the Name of Database
- DBLIST=
ls -p /var/lib/mysql | grep / | tr -d / - - # Backup with Database
- for dbname in $DBLIST
- do
- mysqlhotcopy $dbname -u root -p $ROOTPASS $BACKDIR | logger -t mysqlhotcopy
- done复制代码许多系统管理员喜欢用mysqldump --opt来备份数据库,由于比较简单,我这里就不重复了。