#!/bin/bash
. ~/.bashrc
time=$(date "+%Y-%m-%d %H:%M:%S")
echo "${time}"
for ((i=0;i<100;i++));
do printf "%02d " $i;
db_no=`printf "%02d\n" $i`
sed 's/_62/_'"$db_no"'/g' translog.txt > translog_${db_no}.txt
exit
nohup mysql -h1.1.1.1 -P8003 -udyp -pdyp123456 < /home/work/liantiao/test-db/translog_${db_no}.txt > translog_${db_no}.out 2>&1 &
sleep 30s
time=$(date "+%Y-%m-%d %H:%M:%S")
echo "${time}"
done
echo "create_table_translog.sh done"