【mysqldump备份指定数据库表】my_dump.sh

ewr21

【mysqldump备份指定数据库表】my_dump.sh

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42

#!/bin/bash # # 2014/12/12 function dump_db_table() {     local d_db_base='/data/svr/mysql'     local s_datetime=$(date +%Y%m%d_%H%M%S)     local s_port=3306     local s_password='xxx'     local s_db=$1     if [ -z ${s_port} ]; then         echo "Usage: $0 database table"         exit 2;     fi     local s_table=$2     local d_backup="/home/backup/mysql/${s_port}/mysqldump/${s_db}"           if [ -z ${s_table} ]; then         local dump_args="${d_db_base}/bin/mysqldump -h 127.0.0.1 -P ${s_port} -u root --password=${s_password} -B ${s_db}"         local f_dump_tar="${d_backup}/${s_datetime}-${s_db}.gz"     else         local dump_args="${d_db_base}/bin/mysqldump -h 127.0.0.1 -P ${s_port} -u root --password=${s_password} ${s_db} ${s_table}"         local f_dump_tar="${d_backup}/${s_datetime}-${s_table}.gz"     fi     test -d ${d_backup} || mkdir -p ${d_backup}     echo "[+] `date` Port: ${s_port} DB: ${s_db}.${s_table}"     #${d_db_base}/bin/mysqldump -h 127.0.0.1 -P ${s_port} -u root --password=${s_password} ${s_db} ${s_table} |gzip >${f_backup_db_compressed}     ${dump_args} |gzip >${f_dump_tar}     #echo "${dump_args}"     echo "[-] `date` Saved to: ${f_dump_tar}"     echo "[-] `date` Done."     echo     sleep 1s } dump_db_table d_abc t_abc dump_db_table d_def t_def