mysql 数据备份脚本
#!/bin/sh
backup_path=/home/mysqlbak
mysqlbin=/alidata/server/mysql-5.1.57/share/mysql/mysql.server
mysqldatadir=/alidata/server/mysql-5.1.57/var/phpwind87
file=mysql-$(date +%Y%m%d).tar
$mysqlbin stop
sleep 10s
cd $backup_path
oldbak=mysql-$(date '+%Y%m%d' -d '-3 day').tar
unlink $oldbak
sleep 10s
tar -cf $file $mysqldatadir
sleep 10s
$mysqlbin start
其中
backup_path=/home/mysqlbak
mysqlbin=/alidata/server/mysql-5.1.57/share/mysql/mysql.server
mysqldatadir=/alidata/server/mysql-5.1.57/var/phpwind87
根据需要修改
backup_path=/home/mysqlbak 这个目录也要建立好