How to clean DB from old logs in Magento 1.x

How to clean DB from old logs in Magento 1.x

Using MySQL

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;
 
 
login to shell(SSH) 
go with root/shell folder.

execute the below command inside the shell folder
 
php -f log.php clean
 
enter this command to view the log data's size
php -f log.php status
This method will help you to clean the log data's very easy way.
 

Comments

  1. This comment has been removed by a blog administrator.

    ReplyDelete

Post a Comment

Popular posts from this blog

Securing the Pi-hole with fail2ban to prevent DNS Amplification attacks

Python pxssh failed on login. could not set shell prompt