mysql快速导数脚本_linux mysql shell 导数

rm -rf ^bt_*

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where='batchNo="20201101"' businesstravel flight_order_base_info > bt_flight_order_base_info.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where='batchNo="20201101"' businesstravel flight_order_settlement_base_info > bt_fpsbi.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where='batchNo="20201101"' businesstravel flight_order_passenger > bt_flight_order_passenger.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where='batchNo="20201101"' businesstravel order_flight_info > bt_order_flight_info.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where='batchNo="20201101"' businesstravel order_fee > bt_order_fee.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where='batchNo="20201101"' businesstravel settlement_detail > bt_settlement_detail.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where='batchNo="20201101"' businesstravel settlement_order_detail > bt_settlement_order_detail.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where='batchNo="20201101"' businesstravel settlement_client_detail > bt_settlement_client_detail.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where='batchNo="20201101"' businesstravel settlement_hotel_detail > bt_settlement_hotel_detail.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where="apply_num in( select journeyid from businesstravel.flight_order_base_info fobi where batchNo='20201101' union all select hotel_related_journey_no journeyid from settlement_order_detail sod where batchNo='20201101' )" businesstravel oa_apply > bt_oa_apply.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where="apply_num in( select journeyid from businesstravel.flight_order_base_info fobi where batchNo='20201101' union all select hotel_related_journey_no journeyid from settlement_order_detail sod where batchNo='20201101' )" businesstravel trip_user > bt_trip_user.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where="apply_num in( select journeyid from businesstravel.flight_order_base_info fobi where batchNo='20201101' union all select hotel_related_journey_no journeyid from settlement_order_detail sod where batchNo='20201101' )" businesstravel hotel_trip_info > bt_hotel_trip_info.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where="apply_num in( select journeyid from businesstravel.flight_order_base_info fobi where batchNo='20201101' union all select hotel_related_journey_no journeyid from settlement_order_detail sod where batchNo='20201101' )" businesstravel flight_trip_info > bt_flight_trip_info.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where="apply_num in( select journeyid from businesstravel.flight_order_base_info fobi where batchNo='20201101' union all select hotel_related_journey_no journeyid from settlement_order_detail sod where batchNo='20201101' )" businesstravel flight_order > bt_flight_order.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where="apply_num in( select journeyid from businesstravel.flight_order_base_info fobi where batchNo='20201101' union all select hotel_related_journey_no journeyid from settlement_order_detail sod where batchNo='20201101' )" businesstravel hotel_order > bt_hotel_order.sql

mysqldump --compact --skip-disable-keys --skip-add-locks --no-create-info --skip-comments --skip-triggers --where="apply_num in( select journeyid from businesstravel.flight_order_base_info fobi where batchNo='20201101' union all select hotel_related_journey_no journeyid from settlement_order_detail sod where batchNo='20201101' )" businesstravel oa_expenses > bt_oa_expenses.sql