trimming module logs

[jk2008]

Hi

 

Module logs are currently over 5GB. Do you know if its safe to trim the logs (removing logs over 1 months old) via mysql? And what the mysql syntax will be?

 

Thanks for your help in advance.

 

Thanks,

[sentq]

use can clear all log records from admin area, or using this SQL command:

 

TRUNCATE `tblmodulelog`;

 

or delete all records before March 2016

 

DELETE FROM `tblmodulelog` WHERE `date` < '2016-03-01 00:00:00';