使用mysqldump进行mysql数据库备份的完整shell

publish:August 21, 2021 -Saturday by 04007 本站原创文章,转载请注明文章出处：www.04007.cn

本文地址:http://www.04007.cn/article/1050.html

MYSQL账号密码写在vim /etc/mysql/my.cnf文件中，直接mysqldump导出数据库不需要账号密码，完整shell如下。对导出的sql日志文件进行了压缩，并删除原文件，以节省空间。完整shell如下：本文地址:http://www.04007.cn/article/1050.html,未经许可,不得转载.

!/bin/bash
dbname='test'
backtime=`date +%Y-%m-%d_%H%M%S`
ym=`date +%Y-%m`
rootpath='/opt/mysql/backup'
datapath=${rootpath}/${ym}
logfile=${rootpath}/backup.log
if [ ! -x "$datapath" ]; then 
    mkdir -p $datapath
fi

/usr/bin/mysqldump -h127.0.0.1  $dbname --no-tablespaces --single-transaction > ${datapath}/${backtime}.sql

#备份成功以下操作
if [ "$?" == 0 ];then
    cd $datapath
	tar zcvf ${table}${backtime}.tar.gz ${backtime}.sql > /dev/null
	rm -f ${datapath}/${backtime}.sql
    echo "success" >> ${logfile}
else
	echo "fail" >> ${logfile}
fi

本文地址:http://www.04007.cn/article/1050.html,未经许可,不得转载.

本文地址:http://www.04007.cn/article/1050.html 未经许可,不得转载. 手机访问本页请扫描右下方二维码.