Truncate Customer Log tables in Magento

To keep the size of you Magento Database small it helps to truncate your log tables.

The following is for MySQL access to truncate all data in your tables.

Always BACKUP first

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` ;

Twitter: @brentwpeterson on Twitter
Linkedin: http://www.linkedin.com/in/brentwpeterson
View My Magento Profile

← Previous Post Next Post →
Leave a Comment