msql-分库分表备份

###备份表

for tname in ${TLIST}

       do

          mkdir -p /data/db_backup/${TIME}/${dbname}

          ${MYDUMP} ${dbname} ${tname}  --single-transaction --routines --events --master-data=2 |gzip > /data/db_backup/${TIME}/${dbname}/${dbname}_${tname}${TIME}sql.gz

       done

 done

msql-分库分表备份

标签：mysql   shell