Mysql automatic backup and Linuxmysql backup in Linux

Mysql automatic backup and Linuxmysql backup in Linux

#! /Bin/bash
DATE = 'date + % Y-% m-% d-% H: % M-d-3minute'
USER = root
PASSWORD = maybo
BACKUP_DIR = '/home/mysqlbak /'
LOG_DIR = '/home/mysqlbak/mysqlbak_log.log'
DATABASES = 'bbs'
If [! -D $ BACKUP_DIR]; then
Mkdir-p $ BACKUP_DIR
Fi
Echo-e "\ n" >>$ LOG_DIR
Echo-e "----------------------------------------------------------"> $ LOG_DIR
Echo-e "backup data: $ DATE" >>$ LOG_DIR
Echo-e "----------------------------------------------------------"> $ LOG_DIR
Cd $ BACKUP_DIR
For name in $ DATABASES; do
Mysqldump-u $ USER-p $ PASSWORD-R $ name> $ BACKUP_DIR $ DATE '_' $ name '. SQL'
If [$? = 0]; then
Echo $ BACKUP_DIR $ DATE '_' $ name'. SQL BACKUP SUCCESS. '> $ LOG_DIR
Else
Echo $ BACKUP_DIR $ DATE '_' $ name'. SQL BACKUP FAIL. '> $ LOG_DIR
Fi
Done