Skip to content

Instantly share code, notes, and snippets.

@borriglione

borriglione/mage_dump_products_and_categories.sql

Created April 6, 2012 13:17
Show Gist options
  • Save borriglione/2319690 to your computer and use it in GitHub Desktop.
Save borriglione/2319690 to your computer and use it in GitHub Desktop.
Download ZIP
Magento Product and Category Related Tables
Raw
mage_dump_products_and_categories.sql
mysqldump -u dbuser -p dbname cataloginventory_stock_item cataloginventory_stock_status cataloginventory_stock_status_idx catalogsearch_fulltext catalogsearch_query catalogsearch_result 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_flat_store_1 catalog_category_flat_store_2 catalog_category_product catalog_category_product_index catalog_eav_attribute catalog_product_bundle_option catalog_product_bundle_option_value catalog_product_bundle_selection 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_text catalog_product_entity_tier_price catalog_product_entity_varchar catalog_product_flat_1 catalog_product_flat_2 catalog_product_index_eav catalog_product_index_eav_idx 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_idx catalog_product_index_price_tmp catalog_product_index_website catalog_product_link catalog_product_link_attribute catalog_product_link_attribute_int catalog_product_link_type catalog_product_relation catalog_product_website eav_attribute eav_attribute_group eav_attribute_label eav_attribute_option eav_attribute_option_value eav_attribute_set eav_entity eav_entity_attribute eav_entity_datetime eav_entity_decimal eav_entity_int eav_entity_store eav_entity_text eav_entity_type eav_entity_varchar eav_form_element eav_form_fieldset eav_form_fieldset_label eav_form_type eav_form_type_entity > mage_dump_products_and_categories.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment