#/bin/bash
Set-x
#-------------------------------------------------------------
Database=cmdb
User=root
Password=root
#-------------------------------------------------------------
time=$ (Date +%y%m%d%h%m%s)
folder=$ (ls/opt | grep-w mysqldatabase_bak)
#-------------------------------------------------------------
#database Exprot
if [$folder = = Mysqldatabase_bak]; Then
Mysqldump-u$user-p$password $database >/opt/mysqldatabase_bak/$database $time.sql
Zip-r/opt/mysqldatabase_bak/$database $time.sql.zip/opt/mysqldatabase_bak/$database $time.sql
Rm-f/opt/mysqldatabase_bak/$database $time.sql
Else
Mkdir/opt/mysqldatabase_bak
Mysqldump-u$user-p$password $database >/opt/mysqldatabase_bak/$database $time.sql
Zip-r/opt/mysqldatabase_bak/$database $time.sql.zip/opt/mysqldatabase_bak/$database $time.sql
Rm-f/opt/mysqldatabase_bak/$database $time.sql
Fi
#-------------------------------------------------------------
#database periodically delete
Find/opt/mysqldatabase_bak-mtime +7-name "*.zip"-exec rm-rf {} \;
#-------------------------------------------------------------
#crontab
crontab=$ (cat/var/spool/cron/root | grep mysqldatabase_bak_for_centos.sh | awk ' {print $8} ')
if [$crontab = =./mysqldatabase_bak_for_centos.sh]; Then
echo "Crontab is ok!"
Else
echo "1 1 * * * cd/opt/mysqldatabase_bak;bash./mysqldatabase_bak_for_centos.sh" >>/var/spool/cron/root
Fi
#-------------------------------------------------------------
#move
pwd=$ (PWD)
if [$pwd = =/opt/mysqldatabase_bak]; Then
echo "The Scripts directory is ok!"
echo "The Scripts directory Is/opt/mysqldatabase_bak"
Else
CP Mysqldatabase_bak_for_centos.sh/opt/mysqldatabase_bak
Rm-f mysqldatabase_bak_for_centos.sh
Fi
MySQL scheduled backup script