MySQL Data backup

#!/bin/Bashsql_host=localhost #mysql hostsql_user=Root #mysql username#sql_passwd=1&$]|n". J+[[email protected] #User passwordSql_passwd=123456#User passwordsql_db=$(Date+%y%m%d) #database Namebackup_path=/data/mysqlbak #set Slave backup pathfile=$(Date+%y%m%d).Tar. GZ #backup Name and Time#mysql_path=/usr/local/mysql/bin #set The MySQL database bin pathcd $backup _pathif[-D $backup _path/$ (Date+%y%m%D)] ThenCD $backup _path/$(Date+%y%m%d)Elsemkdir$backup _path/$ (Date+%y%m%d) CD $backup _path/$(Date+%y%m%d)fimysqldump-H $SQL _host-u $SQL _user-p$sql_passwd--add-drop-database--add-drop-table-f Test > $SQL _db.sql--single-TransactionSleep 5Tar-CZF $file$SQL _db.sqlSleep Ten#path=/backup/Data=`Date-D'8 day ago'+%y%m%d 'RM-RF $backup _path/"$data"

MySQL Data backup