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.
For that reason, I have a way to clear out the log tables for smaller file transport.
There are three ways to do this:
1. 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.
2. 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.
Keep your log tables clean for site transport.