Skip to content

Instantly share code, notes, and snippets.

@m0n5t3r

m0n5t3r/truncate_logs.sh

Created February 19, 2013 12:00
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save m0n5t3r/4985225 to your computer and use it in GitHub Desktop.
Save m0n5t3r/4985225 to your computer and use it in GitHub Desktop.
Download ZIP
Magento log cleanup
Raw
truncate_logs.sh
echo "dataflow_batch_export
dataflow_batch_import
log_customer
log_quote
log_summary
log_summary_type
log_url
log_url_info
log_visitor
log_visitor_info
log_visitor_online
report_viewed_product_index
report_compared_product_index
report_event" | awk '{print "truncate table "$1";"}' | mysql $db
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment