linux 远程备份mysql数据库_在linux系统中备份远程mysql数据库的脚本文件2则

#!/bin/bash

# Backup database with current date as a part of file name.

# Date: 2007-03-24

echo “Today is `date`.”

echo ” Now begin backup database…”

prefix=db$(date +%Y%m%d%H%M%S) # Needs a leading ‘+’ to invoke formatting.

suffix=sql

filename=$prefix.$suffix

echo “The file name is $filename.”

#Begin backup database.

hostname=yourhostname

username=yourusername

dbname=yourdbname

dbdir=~/yourdbbackupdir

mysqldump -h$hostname -u$username -p $dbname > $dbdir/$filename

#Begin compress backup file with .tar.bz2 format.

compressfile=$filename.tar.bz2

echo “Begin compress $filename into $compressfile…”

cd $dbdir

tar cfj $compressfile $filename

echo “Backup database success.”

exit 0