Linux Mysql 自动备份

写了一个再简单不过的数据备份;

#!/bin/bash
user="root"
pass=""
cd /mnt/sqlBac
echo "You are in backup dir"
filename=`date +%Y%m%d`
mysqldump -u${user} -p${pass} --all-databases > $filename.sql
echo "Your database backup successfully completed"

 

posted @ 2015-06-23 15:08  鱼尾纹  阅读(131)  评论(0编辑  收藏  举报