mysqlマルチテーブルレコードの除外


#!/bin/bash
database="test"
dbuser="root"
dbpasswd="abcdef"
options=""

#        
ignoreTableArray=(wk_ap_info wk_ap_pwd_history)

#      
function mysql_ignoreTable(){
        for table in  ${ignoreTableArray[@]}
        do
                s="--ignore-table="${database}.${table}" "
                options=${options}${s}
        done
        #${options}      
#       echo ${options}
        mysqldump -u${dbuser} -p${dbpasswd} ${database} ${options} >${database}.sql
}

mysql_ignoreTable