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