Linux Automatic backup Mysql database script code _mysql

In the script you can set up a list of database tables that need to be backed up, and the backup files will be compressed by gzip. It should be noted that this script only applies to environments where data consistency requirements are not high.

Copy Code code as follows:

#!/bin/bash
mysql_pwd= "Password"
mysql_dump= "/usr/local/mysql/bin/mysqldump"
cur_year=$ (date + "%Y")
cur_month=$ (date + "%m")
cur_day=$ (date + "%d")
Dump_path= "/usr/backup/mysql/$cur _year-$cur _month/$cur _day"
Arr_tables= (
"Table_1"
"Table_2"
"Table_3"
)
if [!-d "$dump _path"]; Then
Mkdir-p "$dump _path"
Fi
For cur_table in ${arr_tables[*]}; Todo
$mysql _dump-uroot-p$mysql_pwd--opt mydb $cur _table | gzip > $dump _path/$cur _table.sql.gz
Done