Hi All,

How can it be done it logrotate configuration that I wanted to have the logs in six (6) month retention period? I have the following logs and directories of mysql.

[hostname]# ls /var/log/mysql/
2010.05.01/general.log
2010.05.01/error.log
2010.05.02/general.log
2010.05.02/error.log
2010.05.03/general.log
2010.05.03/error.log

Is it possible that the output after doing logrotate could be like the below sample. All compressed logs will be keep until 6 months only. I know there is man page / docs in internet but I can't get the exact configuration to use.

[hostname]# ls /var/log/mysql/
2010.05.01.gz
2010.05.02.gz
2010.05.03.gz
2010.05.27/general.log
2010.05.27/report.log

Thank you.

Regards,
James