Skip to content

Instantly share code, notes, and snippets.

@jonmunson

jonmunson/maintain_magento_logs.sql

Forked from carlosasin/maintain_magento_logs.sql
Last active September 1, 2015 13:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jonmunson/4a6b1cfa99028185ae2d to your computer and use it in GitHub Desktop.
Save jonmunson/4a6b1cfa99028185ae2d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
maintain_magento_logs.sql
TRUNCATE dataflow_batch_export;
TRUNCATE dataflow_batch_import;
TRUNCATE log_customer;
TRUNCATE log_quote;
TRUNCATE log_summary;
TRUNCATE log_summary_type;
TRUNCATE log_url;
TRUNCATE log_url_info;
TRUNCATE log_visitor;
TRUNCATE log_visitor_info;
TRUNCATE log_visitor_online;
TRUNCATE report_viewed_product_index;
TRUNCATE report_compared_product_index;
TRUNCATE report_event;
TRUNCATE catalog_compare_item;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment