Contents:
debug.txt - contains debugging information; opened in overwrite mode ('>') per request
debug.log - contains debugging information; opened in append mode ('>>'); rotated using log_rotate.pl (count => 3)
deployment.sql - contains SELECT query statements from application in production mode; opened in append mode; rotated using log_rotate.pl (count => 3)
development.sql - contains all query statements (SELECT/UPDATE, etc) from application in development mode; rotated using log_rotate.pl (count => 3)
{yyyy-mm-dd}.sql - contains UPDATE/INSERT/DELETE statements from application in production mode; archived in /old daily using log_rotate.pl
file ownership:
{yyyy-mm-dd}.sql 660 www-data:www-data/staff
development.sql 640 raj:raj/staff
debug.txt 666 raj:raj/staff
debug.log 666 raj:raj/staff
To truncate file in use:
sudo cp new_msgs.log new_msgs.log.nn && sudo cat /dev/null > new_msgs.log
sudo chown raj:raj new_msgs.log.nn