Database Backupshell指令碼

標籤：shel   des   server   .sql   mysqld   schema   mysql   ace   hit   

法一：

#!/bin/bash[ ! -d /server/backup ] && mkdir /server/backupmysqldump -u root -A -B >/server/backup/a.sql[ ! -f /server/backup/a.sql ] && mail -s "bak faile" 法二： #!/bin/shDATE=$(date +%Y-%d-%m)DES=/usr/src/mysql_bakMYSQL_U="root"MYSQL_P="123456"MYSQL_H="127.0.0.1"if [ ! -d "$DES" ];thenmkdir -p "$DES"fiDB=$(mysql -u $MYSQL_U -h $MYSQL_H -p$MYSQL_P -Bse ‘show databases‘)for database in $DBdo if [ ! $database == "information_schema" ];thenmysqldump -u $MYSQL_U -h $MYSQL_H -p$MYSQL_P $database |bzip2> "$DES/${DATE}_mysql.gz"fidone 

Database Backupshell指令碼