MySQL backup script

#!/bin/bash

#auto backup MySQL

#xiaosu 2015-08-06

User=root

password=123456

dir_back=/data/' Date +%y%m%d '

Date= ' Date +%y%m%d '

Database=test

#判断用户是否是管理员root

If [$UID-ne 0];then

Echo-e "\033[32mthe script must use root\033[0m"

Sleep 2

Exit

Fi

#判断备份目录是否存在

if [!-D $DIR _back];then

Mkdir-p $DIR _back;

Else

Echo-e "\033[32mthe $DIR _back is exist\033[32m"

Fi

#备份数据库

/usr/local/mysql/bin/mysqldump-u$user-p$password-d $DATABASE > $DIR _back/$DATE. sql

If [-F $DIR _back/$DATE. SQL];then

echo "The Mysqlbackup successfully"

Else

echo "The Mysqlbackup faied"

Fi

This article is from the "Linux---basics" blog, so be sure to keep this source http://perin.blog.51cto.com/10410663/1693253

MySQL backup script