Xtrabackup实现MySQL每天自动热备
#!/bin/bash#By martin.liu
Today=`date +%Y%m%d`
BackupPath=/usr/local/mysql_backup
BackupLog=bak_$Today.log
BackupFile=$Today.tar.gz
DBUser=root
DBPassword='123456'
DBHost=localhost
mkdir -p $BackupPath/$Today
innobackupex --user=$DBUser --password=$DBPassword--slave-info --stream=tar $BackupPath/$Today/ 2> $BackupPath/$Today/$BackupLog | gzip 1> $BackupPath/$Today/$BackupFile
页:
[1]