DB_pass="디비비번"
## 위치 이동 ###
cd /back/mysql/time
### 시간
export nowTime="`/bin/date '+%H'`"
export nowTime2="`/bin/date '+%F'`"
### {tbl_order / tbl_order_memo / tbl_product / tbl_settle / tbl_order_subalju} db table backup
dump_flower1=`/usr/local/mysql/bin/mysqldump flower tbl_order -u root -p${DB_pass} -w"wdate between '${nowTime2} 00:00:00' and '${nowTime2} 23:59:59'" > flower1_tbl_order_$nowTime.sql`;
dump_flower2=`/usr/local/mysql/bin/mysqldump flower tbl_order_memo -u root -p${DB_pass} -w"wdate between '${nowTime2} 00:00:00' and '${nowTime2} 23:59:59'" > flower1_tbl_order_memo_$nowTime.sql`;
dump_flower3=`/usr/local/mysql/bin/mysqldump flower tbl_order_product -u root -p${DB_pass} -w"wdate between '${nowTime2} 00:00:00' and '${nowTime2} 23:59:59'" > flower1_tbl_order_product_$nowTime.sql`;
dump_flower5=`/usr/local/mysql/bin/mysqldump flower tbl_order_settle -u root -p${DB_pass} -w"insert_date between '${nowTime2} 00:00:00' and '${nowTime2} 23:59:59'" > flower1_tbl_order_settle_$nowTime.sql`;
dump_flower6=`/usr/local/mysql/bin/mysqldump flower tbl_order_subalju -u root -p${DB_pass} -w"balju_date between '${nowTime2} 00:00:00' and '${nowTime2} 23:59:59'" > flower1_tbl_order_subalju_$nowTime.sql`;