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 未经许可,不得转载. 手机访问本页请扫描右下方二维码.
![]() |
![]() |
手机扫码直接打开本页面 |