Skip to content

Instantly share code, notes, and snippets.

@petarBozovic
Created January 12, 2024 22:12
Show Gist options
  • Save petarBozovic/755087ecbb6fe25ed532e0410b71ac9e to your computer and use it in GitHub Desktop.
Save petarBozovic/755087ecbb6fe25ed532e0410b71ac9e to your computer and use it in GitHub Desktop.
sed stuff
gsed -i '/^INSERT INTO `report_viewed_product_index.*/d' ./db.sql
gsed -i '/^INSERT INTO `report_viewed_product_index.*/d' ./db.sql
gsed -i '/^INSERT INTO `report_viewed_product_index.*/d' ./db.sql
gsed -i '/^INSERT INTO `report_viewed_product_index.*/d' ./db.sql
gsed -i '/^INSERT INTO `report_viewed_product_index.*/d' ./db.sql
gsed -i '/^INSERT INTO `report_viewed_product_index.*/d' ./db.sql
gsed -i '/^INSERT INTO `report_viewed_product_index.*/d' ./db.sql
gsed -i '/^INSERT INTO `report_viewed_product_index.*/d' ./db.sql
gsed -i '/^INSERT INTO `report_viewed_product_index.*/d' ./db.sql
gsed -i '/^INSERT INTO `report_viewed_product_index.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_creditmemo.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_creditmemo_comment.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_creditmemo_grid.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_creditmemo_item.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_invoice.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_invoiced_aggregated.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_invoiced_aggregated_order.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_invoice_comment.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_invoice_grid.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_invoice_item.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_order.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_order_address.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_order_aggregated_created.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_order_aggregated_updated.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_order_grid.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_order_item.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_order_payment.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_order_status_history.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_order_tax.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_order_tax_item.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_payment_transaction.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_refunded_aggregated.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_refunded_aggregated_order.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_shipment.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_shipment_comment.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_shipment_grid.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_shipment_item.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_shipment_track.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_shipping_aggregated.*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_shipping_aggregated_order.*/d' ./db.sql
gsed -i '/^INSERT INTO `quote.*/d' ./db.sql
gsed -i '/^INSERT INTO `quote_address.*/d' ./db.sql
gsed -i '/^INSERT INTO `quote_address_item.*/d' ./db.sql
gsed -i '/^INSERT INTO `quote_id_mask.*/d' ./db.sql
gsed -i '/^INSERT INTO `quote_item.*/d' ./db.sql
gsed -i '/^INSERT INTO `quote_item_option.*/d' ./db.sql
gsed -i '/^INSERT INTO `quote_payment.*/d' ./db.sql
gsed -i '/^INSERT INTO `quote_shipping_rate.*/d' ./db.sql
gsed -i '/^INSERT INTO `tax_order_aggregated_created*/d' ./db.sql
gsed -i '/^INSERT INTO `tax_order_aggregated_updated*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_bestsellers_aggregated_daily*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_bestsellers_aggregated_monthly*/d' ./db.sql
gsed -i '/^INSERT INTO `sales_bestsellers_aggregated_yearly*/d' ./db.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment