Plesk log rotate

Posted by alex almazan Sun, 13 Apr 2008 06:46:00 GMT

Here is a query to be run against the psa database for rotating all logs for hosted Apache domains. Ensure that use issue ‘database psa’ prior to running the join

mysql>  select a.*,b.name from log_rotation a join domains b on a.id=b.id where turned_on="true";