Skip to content

Instantly share code, notes, and snippets.

@khoimm92

khoimm92/catalog_dump.sql

Forked from markshust/catalog_dump.sql
Last active October 1, 2021 06:23
Show Gist options
  • Save khoimm92/852ad79883e8cbe8f65614ec8d4e387d to your computer and use it in GitHub Desktop.
Save khoimm92/852ad79883e8cbe8f65614ec8d4e387d to your computer and use it in GitHub Desktop.
Download ZIP
magento2 dump all catalog tables
Raw
catalog_dump.sql
mysqldump -uUSER -p DATABASE catalog_category_entity catalog_category_entity_datetime catalog_category_entity_decimal catalog_category_entity_int catalog_category_entity_text catalog_category_entity_varchar catalog_category_product catalog_category_product_cl catalog_category_product_index catalog_category_product_index_replica catalog_category_product_index_store1 catalog_category_product_index_store1_replica catalog_category_product_index_tmp catalog_compare_item catalog_eav_attribute catalog_product_attribute_cl catalog_product_bundle_option catalog_product_bundle_option_value catalog_product_bundle_price_index catalog_product_bundle_selection catalog_product_bundle_selection_price catalog_product_bundle_stock_index catalog_product_category_cl catalog_product_entity catalog_product_entity_datetime catalog_product_entity_decimal catalog_product_entity_gallery catalog_product_entity_int catalog_product_entity_media_gallery catalog_product_entity_media_gallery_value catalog_product_entity_media_gallery_value_to_entity catalog_product_entity_media_gallery_value_video catalog_product_entity_text catalog_product_entity_tier_price catalog_product_entity_varchar catalog_product_frontend_action catalog_product_index_eav catalog_product_index_eav_decimal catalog_product_index_eav_decimal_idx catalog_product_index_eav_decimal_replica catalog_product_index_eav_decimal_tmp catalog_product_index_eav_idx catalog_product_index_eav_replica catalog_product_index_eav_tmp catalog_product_index_price catalog_product_index_price_bundle_idx catalog_product_index_price_bundle_opt_idx catalog_product_index_price_bundle_opt_tmp catalog_product_index_price_bundle_sel_idx catalog_product_index_price_bundle_sel_tmp catalog_product_index_price_bundle_tmp catalog_product_index_price_cfg_opt_agr_idx catalog_product_index_price_cfg_opt_agr_tmp catalog_product_index_price_cfg_opt_idx catalog_product_index_price_cfg_opt_tmp catalog_product_index_price_downlod_idx catalog_product_index_price_downlod_tmp catalog_product_index_price_final_idx catalog_product_index_price_final_tmp catalog_product_index_price_idx catalog_product_index_price_opt_agr_idx catalog_product_index_price_opt_agr_tmp catalog_product_index_price_opt_idx catalog_product_index_price_opt_tmp catalog_product_index_price_replica catalog_product_index_price_tmp catalog_product_index_tier_price catalog_product_index_website catalog_product_link catalog_product_link_attribute catalog_product_link_attribute_decimal catalog_product_link_attribute_int catalog_product_link_attribute_varchar catalog_product_link_type catalog_product_option catalog_product_option_price catalog_product_option_title catalog_product_option_type_price catalog_product_option_type_title catalog_product_option_type_value catalog_product_price_cl catalog_product_relation catalog_product_super_attribute catalog_product_super_attribute_label catalog_product_super_link catalog_product_website catalog_url_rewrite_product_category cataloginventory_stock cataloginventory_stock_cl cataloginventory_stock_item cataloginventory_stock_status cataloginventory_stock_status_idx cataloginventory_stock_status_replica cataloginventory_stock_status_tmp catalogrule catalogrule_customer_group catalogrule_group_website catalogrule_group_website_replica catalogrule_product catalogrule_product_cl catalogrule_product_price catalogrule_product_price_replica catalogrule_product_replica catalogrule_rule_cl catalogrule_website catalogsearch_fulltext_cl catalogsearch_recommendations > catalog_dump.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment