shell命令导出多张数据库表@TOC
HOSTNAME=localhost
PORT="3306"
USERNAME="root"
PASSWORD="123456"
DBNAME="yingzhang"
for table in {s_config,b_bill_user}
do
mysqldump -h ${HOSTNAME} -P${PORT} -u${USERNAME} -p${PASSWORD} --extended-insert=false ${DBNAME} ${table} >> dump.sql
done
echo 'success'