Shell Script (iii)

1. Automatically back up database scripts
   

#!/bin/bash
#auto Bakcup MySQL
#by 2015-7-2

Bak_dir= "/data/backup/' Date +%y%m%d '"
Mysql_db=discuz
Mysql_user=root
mysql_pw=123456
Mysql_cmd=/usr/bin/mysqldump

If [$UID-ne 0]; Then

echo "must to is use the root for run shell ..."

Exit
Fi

if [!-d "$BAK _dar"]; Then

Mkdir-p $BAK _dir

Echo-e "\033[32mthe $BAK _dir is create successfully\033[0m"

Else
echo "This $BAK _dir is exists ..."

Fi
#mysql Backup commend
$MYSQL _cmd-u$mysql_user-p$mysql_pw $MYSQL _db> $BAK _dir/$MYSQL _db.sql

If [$?-eq 0]; Then

Echo-e "\033[32mthe MySQL $MYSQL _db is backup successfully\033[0m"
Else
Echo-e "\033[32mthe MySQL $MYSQL _db is backup failed,please check\033[0m"

Fi

This article is from the "Fluffy Duck" blog, please be sure to keep this source http://woshitieren.blog.51cto.com/2466034/1670336

Shell Script (iii)