mysql自動備份

標籤：mysql備份指令碼

第一個mysql自動備份指令碼。

#!/bin/bash

#auto backup mysql database for test

#by hag

backCMD=/usr/bin/mysqldump

dbuser=root

dbpasswd=admin123

databasename=test

backup_dir=/opt/backup/mysql

if [ ! -d $backup_dir ]; then

    mkdir -p $backup_dir

fi

if [ $UID -ne 0 ]; then

  echo "must be root can  run the script!"

fi

$backCMD -u$dbuser -p$dbpasswd $databasename > $backup_dir/nimeide.sql

if [ $? -eq 0 ]; then

 echo " this backup mysql successfully!"

  else

  echo " this backup mysql failed!"

fi

~     

寫好指令碼後，賦予執行許可權

[[email protected] script]# chmod 755 backmysql.sh

sh +x 調式指令碼  sh +n 檢測指令碼是否有錯誤！

[[email protected] script]# sh +x backmysql.sh 

 this backup mysql successfully!

本文出自 “清香悠遠” 部落格，請務必保留此出處http://5604671.blog.51cto.com/5594671/1614970

mysql自動備份