这是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来备份数据库,由于比较简单,我这里就不重复了。