Mysql DB 덤프 쉘 스크립트 (다수 테이블)

#!/bin/sh

table_list=“{tables}”

for table in $table_list ; do

 mysqldump --single-transaction -u{remote} -p{pwd} -h{ip} $table > ${table}.sql

 {mysqlpath/}mysql -u{local} -p{pwd} -h{localhost} {table} < ${table}.sql

done