MySQL Automatic backup script

#!/bin/bash

bak_dir=/tmp/' Date +%y%m%d '

Mysqldb=test

Mysqlusr=root

mysqlpw=123456

Mysqlcmd=/usr/bin/mysqldump

If [$UID-ne 0];then

echo "You must is use root";

Exit

Fi

if [!-D $bak _dir];then

Mkdir-p $bak _dir

echo "$bak _dir is create OK";

Else

echo "This $bak _dir is already exists";

Fi

$mysqlcmd-U$MYSQLUSR-P$MYSQLPW $mysqldb > $bak _dir/$mysqldb. sql

If [$?-eq 0];then

echo "The database $mysqldb is backup OK"

Else

echo "The database $mysqldb is backup error"

Fi

Automatic backup

Crontab E

* * * */bin/bash/tmp/mysql_back.sh

MySQL Automatic backup script