please use the following queries to generate a dump free of PII for us to replicate your environment. Replace the corresponding values for <your_user>, <your_db>. Please note that 2 files will be generated. dump_data_structure_only.sql and dump_data_without_pii.sql. Simply create a zip file from these 2 sql files and send it to us.
mysqldump -u <your_user> -p <your_db> --no-data > dump_data_structure_only.sql
mysqldump -u <your_user> -p <your_db> --ignore-table=<your_db>.customer_address_entity --ignore-table=<your_db>.customer_address_entity_datetime --ignore-table=<your_db>.customer_address_entity_decimal --ignore-table=<your_db>.customer_address_entity_int --ignore-table=<your_db>.customer_address_entity_text --ignore-table=<your_db>.customer_address_entity_varchar --ignore-table=<your_db>.customer_entity --ignore-table=<your_db>.customer_entity_datetime --ignore-table=<your_db>.customer_entity_decimal --ignore-table=<your_db>.customer_entity_int --ignore-table=<your_db>.customer_entity_text --ignore-table=<your_db>.customer_entity_varchar --ignore-table=<your_db>.customer_grid_flat --ignore-table=<your_db>.customer_log --ignore-table=<your_db>.customer_visitor --ignore-table=<your_db>.newsletter_subscriber --ignore-table=<your_db>.product_alert_price --ignore-table=<your_db>.product_alert_stock --ignore-table=<your_db>.vault_payment_token --ignore-table=<your_db>.vault_payment_token_order_payment_link --ignore-table=<your_db>.wishlist --ignore-table=<your_db>.wishlist_item --ignore-table=<your_db>.wishlist_item_option --ignore-table=<your_db>.catalogsearch_recommendations --ignore-table=<your_db>.core_session --ignore-table=<your_db>.log_url --ignore-table=<your_db>.log_url_info --ignore-table=<your_db>.log_visitor --ignore-table=<your_db>.log_visitor_info \
--ignore-table=<your_db>.log_visitor_online --ignore-table=<your_db>.report_event --ignore-table=<your_db>.report_compared_product_index --ignore-table=<your_db>.report_viewed_product_aggregated_daily --ignore-table=<your_db>.report_viewed_product_aggregated_monthly --ignore-table=<your_db>.report_viewed_product_aggregated_yearly --ignore-table=<your_db>.report_viewed_product_index --ignore-table=<your_db>.quote --ignore-table=<your_db>.quote_address --ignore-table=<your_db>.quote_address_item --ignore-table=<your_db>.quote_id_mask --ignore-table=<your_db>.quote_item --ignore-table=<your_db>.quote_item_option --ignore-table=<your_db>.quote_payment --ignore-table=<your_db>.quote_shipping_rate --ignore-table=<your_db>.sales_order --ignore-table=<your_db>.sales_order_address --ignore-table=<your_db>.sales_order_aggregated_created --ignore-table=<your_db>.sales_order_aggregated_updated --ignore-table=<your_db>.sales_order_grid --ignore-table=<your_db>.sales_order_item --ignore-table=<your_db>.sales_order_payment --ignore-table=<your_db>.sales_order_status_history --ignore-table=<your_db>.sales_order_tax --ignore-table=<your_db>.sales_order_tax_item --ignore-table=<your_db>.sales_invoice --ignore-table=<your_db>.sales_invoice_comment --ignore-table=<your_db>.sales_invoiced_aggregated --ignore-table=<your_db>.sales_invoiced_aggregated_order --ignore-table=<your_db>.sales_invoice_grid \
--ignore-table=<your_db>.sales_invoice_item \
--ignore-table=<your_db>.sales_shipment --ignore-table=<your_db>.sales_shipment_comment --ignore-table=<your_db>.sales_shipment_grid --ignore-table=<your_db>.sales_shipment_item --ignore-table=<your_db>.sales_shipment_track --ignore-table=<your_db>.sales_shipping_aggregated --ignore-table=<your_db>.sales_shipping_aggregated_order --ignore-table=<your_db>.sales_creditmemo --ignore-table=<your_db>.sales_creditmemo_comment --ignore-table=<your_db>.sales_creditmemo_grid --ignore-table=<your_db>.sales_creditmemo_item --ignore-table=<your_db>.sales_refunded_aggregated --ignore-table=<your_db>.sales_refunded_aggregated_order --ignore-table=<your_db>.sales_payment_transaction --ignore-table=<your_db>.sales_bestsellers_aggregated_daily --ignore-table=<your_db>.sales_bestsellers_aggregated_monthly --ignore-table=<your_db>.sales_bestsellers_aggregated_yearly --ignore-table=<your_db>.paypal_billing_agreement --ignore-table=<your_db>.paypal_billing_agreement_order --ignore-table=<your_db>.paypal_payment_transaction --ignore-table=<your_db>.paypal_settlement_report --ignore-table=<your_db>.paypal_settlement_report_row > dump_data_without_pii.sql