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`;