mysqldump 备份数据库脚本

最新推荐文章于 2024-09-16 18:47:12 发布

原创最新推荐文章于 2024-09-16 18:47:12 发布 · 375 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了一个使用mysqldump进行MySQL数据库全量备份并使用bzip2压缩的bash脚本。该脚本适用于需要定期备份MySQL数据库的场景，并确保备份文件能够被妥善保存。

mysqldump 备份mysql数据库并压缩为bz2

#!/bin/bash

#program
#this scrpt is for the full backup of the database
#history
#2016/12/7 lilei frist release
USER=root
PASSWD=123456
BACKPATH=/mydata/backup
BACKFILE=$(date +%F-%H-%M-%S)
if [ ! -d ${BACKPATH} ]; then
echo " this directory is not exits! please create ${BACKPATH} directory! "
mkdir -v -p -m=rwxrr ${BACKPATH}
if [ $? == 0 ]; then

echo " create directory success!!"

#perform full backup

mysqldump -u${USER} -p${PASSWD} urionzp2p --opt |bzip2 > ${BACKPATH}/${BACKFILE}.sql.bz2
if [ $? -eq 0 ]; then
echo " test database backup success!!"
else
echo " test databsae backup failed!!"
fi
else
echo " create directory failed !! "
fi
else

#perform full backup
mysqldump -uroot -pxbddai8823xbd urionzp2p --opt |bzip2 > ${BACKPATH}/${BACKFILE}.sql.bz2
if [ $? -eq 0 ]; then
echo " test database backup success!!"
else
echo " test databsae backup failed!!"
fi
fi
~