自动备份数据库的Shell-fasdfasdf
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# #!/bin/bashhttp://blog.51cto.com/drinkey/images/editer/None.gif# ######################################################################http://blog.51cto.com/drinkey/images/editer/None.gif# # ScriptName : AMBT.sh--Auto Mysql Backup Tool #
http://blog.51cto.com/drinkey/images/editer/None.gif# # Date : 2007 - 10 - 04 Thu #
http://blog.51cto.com/drinkey/images/editer/None.gif# # Author : Drinkey http://drinkey.syclover.cn #
http://blog.51cto.com/drinkey/images/editer/None.gif# # Version : 0.1 'Not finished yet... #
http://blog.51cto.com/drinkey/images/editer/None.gif# # #
http://blog.51cto.com/drinkey/images/editer/None.gif# # Descrition : You can use this script to backup your database, #
http://blog.51cto.com/drinkey/images/editer/InBlock.gifDiscuz! ,it can read the database #
http://blog.51cto.com/drinkey/images/editer/None.gif# # and backup your database automaticly.If you're using#
http://blog.51cto.com/drinkey/images/editer/None.gif# # others,you can enter the infomation on your keyboard. #
http://blog.51cto.com/drinkey/images/editer/None.gif# # #
http://blog.51cto.com/drinkey/images/editer/None.gif# # Useage : $PWD/ambt path_of_the_CONFIG.INC.PHP #
http://blog.51cto.com/drinkey/images/editer/None.gif# # $PWD/ambt , then enter your Infomation of your DB #
http://blog.51cto.com/drinkey/images/editer/None.gif# # #
http://blog.51cto.com/drinkey/images/editer/None.gif# # Note : The user and password you entered or the user of Discu#
http://blog.51cto.com/drinkey/images/editer/None.gif# # z!,they're supposed to has permission to backup your#
http://blog.51cto.com/drinkey/images/editer/None.gif# # database. #
http://blog.51cto.com/drinkey/images/editer/None.gif# ######################################################################
http://blog.51cto.com/drinkey/images/editer/None.gif# CONF='config.inc.php'
http://blog.51cto.com/drinkey/images/editer/None.gif# ROOT_UID=0
http://blog.51cto.com/drinkey/images/editer/None.gif# E_NOTEXIST=65
http://blog.51cto.com/drinkey/images/editer/None.gif# PREFIX='mysql_backup'
http://blog.51cto.com/drinkey/images/editer/None.gif# DUMPFILE=$PWD/$PREFIX$(date +%y%m%d).sql
http://blog.51cto.com/drinkey/images/editer/None.gif#
http://blog.51cto.com/drinkey/images/editer/None.gif# #------IF the user is NOT root,asking for some infomation --------#
http://blog.51cto.com/drinkey/images/editer/None.gif# if [ "$UID" -ne "$ROOT_UID" ]; then
http://blog.51cto.com/drinkey/images/editer/None.gif# echo -e "You're NOT ROOT.\n"
http://blog.51cto.com/drinkey/images/editer/None.gif# echo -e "Please Enter the info of database which you want backup.\n"
http://blog.51cto.com/drinkey/images/editer/None.gif# echo "Database Name:"
http://blog.51cto.com/drinkey/images/editer/None.gif# read N_DBName
http://blog.51cto.com/drinkey/images/editer/None.gif# echo "Database User:"
http://blog.51cto.com/drinkey/images/editer/None.gif# read N_DBUser
http://blog.51cto.com/drinkey/images/editer/None.gif# echo "Database Password:"
http://blog.51cto.com/drinkey/images/editer/None.gif# read N_DBPassword
http://blog.51cto.com/drinkey/images/editer/None.gif#
http://blog.51cto.com/drinkey/images/editer/None.gif# #------IF there's a file with same name,means he has backuped today ----#
http://blog.51cto.com/drinkey/images/editer/None.gif# if [ -x "$DUMPFILE" ]; then
http://blog.51cto.com/drinkey/images/editer/None.gif# echo "You've backuped your database today."
http://blog.51cto.com/drinkey/images/editer/None.gif# echo "If you want backup anyway,please delete $DUMPFILE"
http://blog.51cto.com/drinkey/images/editer/None.gif# else
http://blog.51cto.com/drinkey/images/editer/None.gif# mysqldump -u$N_DBUser -p$N_DBPassword --opt $N_DBName > $DUMPFILE
http://blog.51cto.com/drinkey/images/editer/None.gif# sleep 1
http://blog.51cto.com/drinkey/images/editer/None.gif# echo "Backup complet!"
http://blog.51cto.com/drinkey/images/editer/None.gif# fi
http://blog.51cto.com/drinkey/images/editer/None.gif#
http://blog.51cto.com/drinkey/images/editer/None.gif# else
http://blog.51cto.com/drinkey/images/editer/None.gif# #------The path the user entered is correct??-------#
http://blog.51cto.com/drinkey/images/editer/None.gif# if [ -x "$1$CONF" ]; then
http://blog.51cto.com/drinkey/images/editer/None.gif# COFILE="$1$CONF"
http://blog.51cto.com/drinkey/images/editer/None.gif# echo "File exists,read info from $COFILE."
http://blog.51cto.com/drinkey/images/editer/None.gif# awk -F\' '/\$dbuser/ { print "User: "$2}' $COFILE > $PWD/tmp
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# awk -F\' '/\$dbpw/ { print "Passwd: "$2}' $COFILE >> $PWD/tmp
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# awk -F\' '/\$dbname/ { print "DBName: "$2}' $COFILE >> $PWD/tmp
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# sleep 1
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# DBUser="`awk '/User/{print $2}' tmp`"
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# DBName="`awk '/DBName/{print $2}' tmp`"
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# DBPassword="`awk '/Passwd/{print $2}' tmp`"
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# sleep 1
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# mysqldump -u$DBUser -p$DBPassword $DBName > $DUMPFILE
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# echo "Backup complet!"
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# rm -f tmp
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# else
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# echo "File not exists,Please check the path."
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# exit $E_NOTEXIST
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# fi
http://blog.51cto.com/drinkey/images/editer/InBlock.gif#
http://blog.51cto.com/drinkey/images/editer/InBlock.gif# fi
页:
[1]