Shulou(Shulou.com)06/01 Report--

#! / bin/bash

# back_mysql by 2016-11-14

Bak_dir=/data/backup_db/ `date +% Y% m% d`

Mysqldb=mysql

Mysqluser=*

Mysqlpw=*

If [$UID-ne 0]; then

Echo "must to be use root for exec shell"

Exit

Fi

# determine whether there is a file,\ 033 [32m is displayed in color

If [!-d $bak_dir]; then

Mkdir-p $bak_dir

Echo-e "\ 033 [32mThe $bak_dir create successfully!\ 033 [0m"

Else

Echo "This $bak_dir is exists...."

Fi

# backup statement

Mysqldump-u$mysqluser-p$mysqlpw-d $mysqldb > $bak_dir/$mysqldb.sql.tar.gz

# whether the backup is successful

If [$?-eq 0]; then

Echo-e "\ 033 [32mThe mysql backup $mysqldb successfully\ 033 [0m"

Else

Echo-e "\ 033 [32mThe mysql backup $mysqldb failed .cake check!\ 033 [0m"

Fi

# execute scripts and backup results

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.