本文介绍了一个用于MySQL数据库备份的Shell脚本。该脚本通过读取数据库列表并使用mysqldump工具进行逐个备份，之后将所有.sql文件压缩归档，并清理原始的.sql文件以节省磁盘空间。
#!/bin/sh
# by liyuan
date=`date +%Y-%m-%d`
backup_path='/data/mysqlbak/'
for database in `cat ${backup_path}db.txt`; do
/alidata/server/mysql-5.5.37/bin/mysqldump -uroot -p****** --master-data $database >${backup_path}${database}.sql
done
cd ${backup_path}
tar zcf ${date}.sql.tar.gz *.sql
rm -rf *.sql
# by liyuan
date=`date +%Y-%m-%d`
backup_path='/data/mysqlbak/'
for database in `cat ${backup_path}db.txt`; do
/alidata/server/mysql-5.5.37/bin/mysqldump -uroot -p****** --master-data $database >${backup_path}${database}.sql
done
cd ${backup_path}
tar zcf ${date}.sql.tar.gz *.sql
rm -rf *.sql
扫一扫
2024
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
