backup_live_magento_data.sh

#!/bin/sh
 
mysqldump --single-transaction \
--ignore-table=DBNAME.catalog_category_anc_categs_index_idx \
--ignore-table=DBNAME.catalog_category_anc_categs_index_tmp \
--ignore-table=DBNAME.catalog_category_anc_products_index_idx \
--ignore-table=DBNAME.catalog_category_anc_products_index_tmp \
--ignore-table=DBNAME.catalog_category_product_index \
--ignore-table=DBNAME.catalog_category_product_index_enbl_idx \
--ignore-table=DBNAME.catalog_category_product_index_enbl_tmp \
--ignore-table=DBNAME.catalog_category_product_index_idx \
--ignore-table=DBNAME.catalog_category_product_index_tmp \
--ignore-table=DBNAME.catalog_product_bundle_price_index \
--ignore-table=DBNAME.catalog_product_bundle_stock_index \
--ignore-table=DBNAME.catalog_product_enabled_index \
--ignore-table=DBNAME.catalog_product_index_eav \
--ignore-table=DBNAME.catalog_product_index_eav_decimal \
--ignore-table=DBNAME.catalog_product_index_eav_decimal_idx \
--ignore-table=DBNAME.catalog_product_index_eav_decimal_tmp \
--ignore-table=DBNAME.catalog_product_index_eav_idx \
--ignore-table=DBNAME.catalog_product_index_eav_tmp \
--ignore-table=DBNAME.catalog_product_index_price \
--ignore-table=DBNAME.catalog_product_index_price_bundle_idx \
--ignore-table=DBNAME.catalog_product_index_price_bundle_opt_idx \
--ignore-table=DBNAME.catalog_product_index_price_bundle_opt_tmp \
--ignore-table=DBNAME.catalog_product_index_price_bundle_sel_idx \
--ignore-table=DBNAME.catalog_product_index_price_bundle_sel_tmp \
--ignore-table=DBNAME.catalog_product_index_price_bundle_tmp \
--ignore-table=DBNAME.catalog_product_index_price_cfg_opt_agr_idx \
--ignore-table=DBNAME.catalog_product_index_price_cfg_opt_agr_tmp \
--ignore-table=DBNAME.catalog_product_index_price_cfg_opt_idx \
--ignore-table=DBNAME.catalog_product_index_price_cfg_opt_tmp \
--ignore-table=DBNAME.catalog_product_index_price_downlod_idx \
--ignore-table=DBNAME.catalog_product_index_price_downlod_tmp \
--ignore-table=DBNAME.catalog_product_index_price_final_idx \
--ignore-table=DBNAME.catalog_product_index_price_final_tmp \
--ignore-table=DBNAME.catalog_product_index_price_idx \
--ignore-table=DBNAME.catalog_product_index_price_opt_agr_idx \
--ignore-table=DBNAME.catalog_product_index_price_opt_agr_tmp \
--ignore-table=DBNAME.catalog_product_index_price_opt_idx \
--ignore-table=DBNAME.catalog_product_index_price_opt_tmp \
--ignore-table=DBNAME.catalog_product_index_price_tmp \
--ignore-table=DBNAME.catalog_product_index_tier_price \
--ignore-table=DBNAME.catalog_product_index_website \
--ignore-table=DBNAME.dataflow_batch_export \
--ignore-table=DBNAME.dataflow_batch_import \
--ignore-table=DBNAME.log_url \
--ignore-table=DBNAME.log_url_info \
--ignore-table=DBNAME.log_visitor \
--ignore-table=DBNAME.log_visitor_info \
--ignore-table=DBNAME.log_visitor_online \
--ignore-table=DBNAME.core_session \
--ignore-table=DBNAME.report_event \
--ignore-table=DBNAME.log_customer \
--ignore-table=DBNAME.report_viewed_product_index \
--ignore-table=DBNAME.customer_address_entity \
--ignore-table=DBNAME.customer_address_entity_datetime \
--ignore-table=DBNAME.customer_address_entity_decimal \
--ignore-table=DBNAME.customer_address_entity_int \
--ignore-table=DBNAME.customer_address_entity_text \
--ignore-table=DBNAME.customer_address_entity_varchar \
--ignore-table=DBNAME.customer_entity \
--ignore-table=DBNAME.customer_entity_datetime \
--ignore-table=DBNAME.customer_entity_decimal \
--ignore-table=DBNAME.customer_entity_int \
--ignore-table=DBNAME.customer_entity_text \
--ignore-table=DBNAME.customer_entity_varchar \
--ignore-table=DBNAME.sales_flat_order \
--ignore-table=DBNAME.sales_flat_order_address \
--ignore-table=DBNAME.sales_flat_order_grid \
--ignore-table=DBNAME.sales_flat_order_item \
--ignore-table=DBNAME.sales_flat_order_payment \
--ignore-table=DBNAME.sales_flat_order_status_history \
--ignore-table=DBNAME.sales_flat_quote \
--ignore-table=DBNAME.sales_flat_quote_address \
--ignore-table=DBNAME.sales_flat_quote_address_item \
--ignore-table=DBNAME.sales_flat_quote_item \
--ignore-table=DBNAME.sales_flat_quote_item_option \
--ignore-table=DBNAME.sales_flat_quote_payment \
--ignore-table=DBNAME.sales_flat_quote_shipping_rate \
--ignore-table=DBNAME.enterprise_sales_creditmemo_grid_archive \
--ignore-table=DBNAME.enterprise_sales_invoice_grid_archive \
--ignore-table=DBNAME.enterprise_sales_order_grid_archive \
--ignore-table=DBNAME.enterprise_sales_shipment_grid_archive \
--ignore-table=DBNAME.sales_flat_creditmemo \
--ignore-table=DBNAME.sales_flat_creditmemo_comment \
--ignore-table=DBNAME.sales_flat_creditmemo_grid \
--ignore-table=DBNAME.sales_flat_creditmemo_item \
--ignore-table=DBNAME.sales_flat_invoice \
--ignore-table=DBNAME.sales_flat_invoice_comment \
--ignore-table=DBNAME.sales_flat_invoice_grid \
--ignore-table=DBNAME.sales_flat_invoice_item \
--ignore-table=DBNAME.sales_flat_shipment \
--ignore-table=DBNAME.sales_flat_shipment_comment \
--ignore-table=DBNAME.sales_flat_shipment_grid \
--ignore-table=DBNAME.sales_flat_shipment_item \
--ignore-table=DBNAME.sales_flat_shipment_track \
--ignore-table=DBNAME.sendfriend_log \
--ignore-table=DBNAME.wishlist \
--ignore-table=DBNAME.wishlist_item \
--ignore-table=DBNAME.wishlist_item_option DBNAME | sed 's/DEFINER=.*.210.//g' | pv | gzip > DBNAME_live.sql.gz