Clean Magento Database
SET FOREIGN_KEY_CHECKS=0; | |
TRUNCATE `catalogsearch_fulltext`; | |
TRUNCATE `catalogsearch_query`; | |
TRUNCATE `catalogsearch_result`; | |
-- | |
-- Enterprise Edition | |
-- | |
TRUNCATE `catalogsearch_fulltext`; | |
TRUNCATE `catalogsearch_fulltext_cl`; | |
TRUNCATE `catalogsearch_query`; | |
TRUNCATE `catalogsearch_recommendations`; | |
TRUNCATE `catalogsearch_result`; | |
SET FOREIGN_KEY_CHECKS=1; |
SET FOREIGN_KEY_CHECKS=0; | |
-- Customers | |
TRUNCATE `customer_address_entity`; | |
TRUNCATE `customer_address_entity_datetime`; | |
TRUNCATE `customer_address_entity_decimal`; | |
TRUNCATE `customer_address_entity_int`; | |
TRUNCATE `customer_address_entity_text`; | |
TRUNCATE `customer_address_entity_varchar`; | |
TRUNCATE `customer_entity`; | |
TRUNCATE `customer_entity_datetime`; | |
TRUNCATE `customer_entity_decimal`; | |
TRUNCATE `customer_entity_int`; | |
TRUNCATE `customer_entity_text`; | |
TRUNCATE `customer_entity_varchar`; | |
ALTER TABLE `customer_address_entity` AUTO_INCREMENT=1; | |
ALTER TABLE `customer_address_entity_datetime` AUTO_INCREMENT=1; | |
ALTER TABLE `customer_address_entity_decimal` AUTO_INCREMENT=1; | |
ALTER TABLE `customer_address_entity_int` AUTO_INCREMENT=1; | |
ALTER TABLE `customer_address_entity_text` AUTO_INCREMENT=1; | |
ALTER TABLE `customer_address_entity_varchar` AUTO_INCREMENT=1; | |
ALTER TABLE `customer_entity` AUTO_INCREMENT=1; | |
ALTER TABLE `customer_entity_datetime` AUTO_INCREMENT=1; | |
ALTER TABLE `customer_entity_decimal` AUTO_INCREMENT=1; | |
ALTER TABLE `customer_entity_int` AUTO_INCREMENT=1; | |
ALTER TABLE `customer_entity_text` AUTO_INCREMENT=1; | |
ALTER TABLE `customer_entity_varchar` AUTO_INCREMENT=1; | |
-- Search | |
TRUNCATE `catalogsearch_query`; | |
TRUNCATE `catalogsearch_fulltext`; | |
TRUNCATE `catalogsearch_result`; | |
ALTER TABLE `catalogsearch_query` AUTO_INCREMENT=1; | |
ALTER TABLE `catalogsearch_fulltext` AUTO_INCREMENT=1; | |
ALTER TABLE `catalogsearch_result` AUTO_INCREMENT=1; | |
-- Polls | |
TRUNCATE `poll`; | |
TRUNCATE `poll_answer`; | |
TRUNCATE `poll_store`; | |
TRUNCATE `poll_vote`; | |
ALTER TABLE `poll` AUTO_INCREMENT=1; | |
ALTER TABLE `poll_answer` AUTO_INCREMENT=1; | |
ALTER TABLE `poll_store` AUTO_INCREMENT=1; | |
ALTER TABLE `poll_vote` AUTO_INCREMENT=1; | |
-- Reports | |
TRUNCATE `report_viewed_product_index`; | |
ALTER TABLE `report_viewed_product_index` AUTO_INCREMENT=1; | |
-- Newsletter | |
TRUNCATE `newsletter_queue`; | |
TRUNCATE `newsletter_queue_link`; | |
TRUNCATE `newsletter_subscriber`; | |
TRUNCATE `newsletter_problem`; | |
TRUNCATE `newsletter_queue_store_link`; | |
ALTER TABLE `newsletter_queue` AUTO_INCREMENT=1; | |
ALTER TABLE `newsletter_subscriber` AUTO_INCREMENT=1; | |
ALTER TABLE `newsletter_problem` AUTO_INCREMENT=1; | |
ALTER TABLE `newsletter_queue_store_link` AUTO_INCREMENT=1; | |
SET FOREIGN_KEY_CHECKS=1; |
SET FOREIGN_KEY_CHECKS=0; | |
TRUNCATE `log_customer`; | |
TRUNCATE `log_visitor`; | |
TRUNCATE `log_visitor_info`; | |
TRUNCATE `log_visitor_online`; | |
TRUNCATE `log_quote`; | |
TRUNCATE `log_summary`; | |
TRUNCATE `log_summary_type`; | |
TRUNCATE `log_url`; | |
TRUNCATE `log_url_info`; | |
TRUNCATE `sendfriend_log`; | |
TRUNCATE `report_event`; | |
TRUNCATE `dataflow_batch_import`; | |
TRUNCATE `dataflow_batch_export`; | |
TRUNCATE `index_process_event`; | |
TRUNCATE `index_event`; | |
ALTER TABLE `log_customer` AUTO_INCREMENT=1; | |
ALTER TABLE `log_visitor` AUTO_INCREMENT=1; | |
ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1; | |
ALTER TABLE `log_visitor_online` AUTO_INCREMENT=1; | |
ALTER TABLE `log_quote` AUTO_INCREMENT=1; | |
ALTER TABLE `log_summary` AUTO_INCREMENT=1; | |
ALTER TABLE `log_url_info` AUTO_INCREMENT=1; | |
ALTER TABLE `sendfriend_log` AUTO_INCREMENT=1; | |
ALTER TABLE `report_event` AUTO_INCREMENT=1; | |
ALTER TABLE `dataflow_batch_import` AUTO_INCREMENT=1; | |
ALTER TABLE `dataflow_batch_export` AUTO_INCREMENT=1; | |
ALTER TABLE `index_event` AUTO_INCREMENT=1; | |
-- | |
-- Enterprise Edition | |
-- | |
TRUNCATE `enterprise_logging_event`; | |
TRUNCATE `enterprise_logging_event_changes`; | |
ALTER TABLE `enterprise_logging_event` AUTO_INCREMENT=1; | |
ALTER TABLE `enterprise_logging_event_changes` AUTO_INCREMENT=1; | |
SET FOREIGN_KEY_CHECKS=1; |
SET FOREIGN_KEY_CHECKS = 0; | |
TRUNCATE TABLE `catalog_product_bundle_option`; | |
TRUNCATE TABLE `catalog_product_bundle_option_value`; | |
TRUNCATE TABLE `catalog_product_bundle_selection`; | |
TRUNCATE TABLE `catalog_product_entity_datetime`; | |
TRUNCATE TABLE `catalog_product_entity_decimal`; | |
TRUNCATE TABLE `catalog_product_entity_gallery`; | |
TRUNCATE TABLE `catalog_product_entity_int`; | |
TRUNCATE TABLE `catalog_product_entity_media_gallery`; | |
TRUNCATE TABLE `catalog_product_entity_media_gallery_value`; | |
TRUNCATE TABLE `catalog_product_entity_text`; | |
TRUNCATE TABLE `catalog_product_entity_tier_price`; | |
TRUNCATE TABLE `catalog_product_entity_varchar`; | |
TRUNCATE TABLE `catalog_product_link`; | |
TRUNCATE TABLE `catalog_product_link_attribute`; | |
TRUNCATE TABLE `catalog_product_link_attribute_decimal`; | |
TRUNCATE TABLE `catalog_product_link_attribute_int`; | |
TRUNCATE TABLE `catalog_product_link_attribute_varchar`; | |
TRUNCATE TABLE `catalog_product_link_type`; | |
TRUNCATE TABLE `catalog_product_option`; | |
TRUNCATE TABLE `catalog_product_option_price`; | |
TRUNCATE TABLE `catalog_product_option_title`; | |
TRUNCATE TABLE `catalog_product_option_type_price`; | |
TRUNCATE TABLE `catalog_product_option_type_title`; | |
TRUNCATE TABLE `catalog_product_option_type_value`; | |
TRUNCATE TABLE `catalog_product_super_attribute`; | |
TRUNCATE TABLE `catalog_product_super_attribute_label`; | |
TRUNCATE TABLE `catalog_product_super_attribute_pricing`; | |
TRUNCATE TABLE `catalog_product_super_link`; | |
TRUNCATE TABLE `catalog_product_enabled_index`; | |
TRUNCATE TABLE `catalog_product_website`; | |
TRUNCATE TABLE `catalog_product_entity`; | |
TRUNCATE TABLE `cataloginventory_stock`; | |
TRUNCATE TABLE `cataloginventory_stock_item`; | |
TRUNCATE TABLE `cataloginventory_stock_status`; | |
TRUNCATE TABLE `catalog_category_entity`; | |
TRUNCATE TABLE `catalog_category_entity_datetime`; | |
TRUNCATE TABLE `catalog_category_entity_decimal`; | |
TRUNCATE TABLE `catalog_category_entity_int`; | |
TRUNCATE TABLE `catalog_category_entity_text`; | |
TRUNCATE TABLE `catalog_category_entity_varchar`; | |
TRUNCATE TABLE `catalog_category_product`; | |
TRUNCATE TABLE `catalog_category_product_index`; | |
TRUNCATE TABLE `catalog_product_relation`; | |
TRUNCATE TABLE `catalog_product_flat_1`; | |
TRUNCATE TABLE `catalog_category_flat_store_1`; | |
TRUNCATE TABLE `catalog_category_flat_store_2`; | |
TRUNCATE TABLE `catalog_category_flat_store_3`; | |
SET FOREIGN_KEY_CHECKS = 1; |
SET FOREIGN_KEY_CHECKS=0; | |
TRUNCATE `sales_payment_transaction`; | |
TRUNCATE `sales_flat_creditmemo`; | |
TRUNCATE `sales_flat_creditmemo_comment`; | |
TRUNCATE `sales_flat_creditmemo_grid`; | |
TRUNCATE `sales_flat_creditmemo_item`; | |
TRUNCATE `sales_flat_order`; | |
TRUNCATE `sales_flat_order_address`; | |
TRUNCATE `sales_flat_order_grid`; | |
TRUNCATE `sales_flat_order_item`; | |
TRUNCATE `sales_flat_order_status_history`; | |
TRUNCATE `sales_flat_quote`; | |
TRUNCATE `sales_flat_quote_address`; | |
TRUNCATE `sales_flat_quote_address_item`; | |
TRUNCATE `sales_flat_quote_item`; | |
TRUNCATE `sales_flat_quote_item_option`; | |
TRUNCATE `sales_flat_order_payment`; | |
TRUNCATE `sales_flat_quote_payment`; | |
TRUNCATE `sales_flat_quote_shipping_rate`; | |
TRUNCATE `sales_flat_shipment`; | |
TRUNCATE `sales_flat_shipment_item`; | |
TRUNCATE `sales_flat_shipment_grid`; | |
TRUNCATE `sales_flat_shipment_track`; | |
TRUNCATE `sales_flat_invoice`; | |
TRUNCATE `sales_flat_invoice_grid`; | |
TRUNCATE `sales_flat_invoice_item`; | |
TRUNCATE `sales_flat_invoice_comment`; | |
TRUNCATE `tag`; | |
TRUNCATE `tag_relation`; | |
TRUNCATE `tag_summary`; | |
TRUNCATE `wishlist`; | |
TRUNCATE `report_event`; | |
TRUNCATE `catalogsearch_fulltext`; | |
-- Reports | |
TRUNCATE `sales_bestsellers_aggregated_daily`; | |
TRUNCATE `sales_bestsellers_aggregated_monthly`; | |
TRUNCATE `sales_bestsellers_aggregated_yearly`; | |
TRUNCATE `sales_invoiced_aggregated`; | |
TRUNCATE `sales_invoiced_aggregated_order`; | |
TRUNCATE `sales_order_aggregated_created`; | |
TRUNCATE `sales_order_aggregated_updated`; | |
TRUNCATE `sales_refunded_aggregated`; | |
TRUNCATE `sales_refunded_aggregated_order`; | |
TRUNCATE `sales_shipping_aggregated`; | |
TRUNCATE `sales_shipping_aggregated_order`; | |
TRUNCATE `coupon_aggregated`; | |
TRUNCATE `review`; | |
TRUNCATE `review_detail`; | |
TRUNCATE `review_entity_summary`; | |
TRUNCATE `rating_store`; | |
-- | |
-- Enterprise Edition | |
-- | |
TRUNCATE `enterprise_reward`; | |
TRUNCATE `enterprise_reward_history`; | |
TRUNCATE `enterprise_customer_sales_flat_quote_address`; | |
TRUNCATE `enterprise_customer_sales_flat_quote`; | |
TRUNCATE `enterprise_customer_sales_flat_order_address`; | |
TRUNCATE `enterprise_customer_sales_flat_order`; | |
ALTER TABLE `sales_payment_transaction` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_creditmemo` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_creditmemo_comment` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_creditmemo_grid` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_creditmemo_item` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_order` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_order_address` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_order_grid` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_order_item` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_order_status_history` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_quote` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_quote_address` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_quote_address_item` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_quote_item` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_quote_item_option` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_order_payment` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_quote_payment` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_quote_shipping_rate` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_shipment` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_shipment_item` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_invoice` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_invoice_grid` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_invoice_item` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_invoice_comment` AUTO_INCREMENT=1; | |
ALTER TABLE `sales_flat_shipment_grid` AUTO_INCREMENT=1; | |
ALTER TABLE `tag` AUTO_INCREMENT=1; | |
ALTER TABLE `tag_relation` AUTO_INCREMENT=1; | |
ALTER TABLE `tag_summary` AUTO_INCREMENT=1; | |
ALTER TABLE `wishlist` AUTO_INCREMENT=1; | |
ALTER TABLE `report_event` AUTO_INCREMENT=1; | |
ALTER TABLE `catalogsearch_fulltext` AUTO_INCREMENT=1; | |
-- | |
-- Enterprise Edition | |
-- | |
ALTER TABLE `enterprise_reward` AUTO_INCREMENT=1; | |
ALTER TABLE `enterprise_reward_history` AUTO_INCREMENT=1; | |
ALTER TABLE `enterprise_customer_sales_flat_quote_address` AUTO_INCREMENT=1; | |
ALTER TABLE `enterprise_customer_sales_flat_quote` AUTO_INCREMENT=1; | |
ALTER TABLE `enterprise_customer_sales_flat_order_address` AUTO_INCREMENT=1; | |
ALTER TABLE `enterprise_customer_sales_flat_order` AUTO_INCREMENT=1; | |
TRUNCATE `eav_entity_store`; | |
ALTER TABLE `eav_entity_store` AUTO_INCREMENT=1; | |
SET FOREIGN_KEY_CHECKS=1; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment