Like all software, Magento 1 likes to log a lot of actions. That is usually useful information and not a problem, but it can make for a larger database that you would like. Especially if you need to copy the site to a new server or a local development environment. Honestly, in my experience, I have rarely had to refer to these logs.<\/p>\n
For that reason, I have a way to clear out the log tables for smaller file transport.<\/p>\n
There are three ways to do this:
\n1. When logged into the admin, go to “System -> Configuration -> Advanced -> System -> Log. Set the log clean time down to a small number. By default on the sites I manage, it’s 180 days. Something like one or two days would keep the tables pretty small.
\n2. Go straight to the database and truncate all of the log tables. Below is the sql code that is tested and approved for this measure.
\n[code]
\nTRUNCATE dataflow_batch_export;
\nTRUNCATE dataflow_batch_import;
\nTRUNCATE log_customer;
\nTRUNCATE log_quote;
\nTRUNCATE log_summary;
\nTRUNCATE log_summary_type;
\nTRUNCATE log_url;
\nTRUNCATE log_url_info;
\nTRUNCATE log_visitor;
\nTRUNCATE log_visitor_info;
\nTRUNCATE log_visitor_online;
\nTRUNCATE report_viewed_product_index;
\nTRUNCATE report_compared_product_index;
\nTRUNCATE report_event;
\nTRUNCATE index_event;
\n[\/code]<\/p>\n
Keep your log tables clean for site transport.<\/p>\n","protected":false},"excerpt":{"rendered":"