MySQL Automatic backup

The first MySQL automatic backup script.

#!/bin/bash

#auto backup MySQL database for test

#by Hag

Backcmd=/usr/bin/mysqldump

Dbuser=root

Dbpasswd=admin123

Databasename=test

Backup_dir=/opt/backup/mysql

if [!-D $backup _dir]; Then

Mkdir-p $backup _dir

Fi

If [$UID-ne 0]; Then

echo "must be root can run the script!"

Fi

$backCMD-u$dbuser-p$dbpasswd $databasename > $backup _dir/nimeide.sql

If [$?-eq 0]; Then

echo "This backup MySQL successfully!"

Else

echo "This backup MySQL failed!"

Fi

~

After writing the script, give execute permission.

[Email protected] script]# chmod 755 backmysql.sh

SH +x Debug Script sh +n detect if there is an error in the script!

[Email protected] script]# sh +x backmysql.sh

This backup MySQL successfully!

This article from "Fragrance Distant" blog, please be sure to keep this source http://5604671.blog.51cto.com/5594671/1614970

MySQL Automatic backup