Linux 上Mysql备份与恢复

Linux 下Mysql备份与恢复

公司项目用到了Mysql的备份与恢复操作

?

现把脚本程序做下笔记

?

Mysql备份与恢复

#!/bin/shdir=/home/atj/data/tmpecho -------DB_Publish-------`if [ ! -e $dir ]; then        mkdir -p $dirfibackup() {        aip=$1        user=$2        pass=$3        db=$4        name=$5        file=$dir/$name.sql        if [ ! -f $file ];then                touch $file        fi        mysqldump -h$aip -u$user -p$pass $db > $file #数据库备份命令        if [ $? != 0 ]; then                echo "ERROR:Database $db backup fail!!!"  exit 0        else                echo "SUCCESS:Database $db backup success! "        fi}        backup $1 $2 $3 db_atj source_backup        backup $4 $5 $6 db_atj target_backup        mysql -h$4 -u$5 -p$6 db_atj1 < $dir/source_backup.sql #数据库恢复操作        if [ $? != 0 ]; then                echo "ERROR:Database publish error !!!"  exit 0        else                echo "SUCCESS:Database publish success !!!"        fiexit 0

?