[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