Linux automatic backup MySQL database script code _ MySQL

Linux automatic backup MySQL database script code bitsCN.com in the script, you can set the list of database tables to be backed up, and will compress the backup files through gzip. Note that this script is only applicable to environments with low data consistency requirements.

#! /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 [*]}; do
$ Mysql_dump-uroot-p $ mysql_pwd -- opt mydb $ cur_table | gzip> $ dump_path/$cur_table. SQL .gz
Done
BitsCN.com