Plesk log rotate

Posted by alex almazan Mon, 31 Dec 2007 21:24:00 GMT

Behind the scenes multi domain log rotation enabling in Plesk 
[root@server1 log]# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7578332 to server version: 4.0.18-Max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

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