Backup Logs Store In Mysql
November 24th, 2009
Use rsync to grab log files that are on a cdn. Log files then need to be sent via sftp to a backup server. If the file already exists on the sftp server it does not need to be stored.
This needs to run every 6 hours or when there are new log files.
An error message needs to be emailed if logs have an issue running.
I also need these log files analyzed daily.
The total # of times a file loaded needs to be stored in mysql.
A basic report is needed that shows the # of times a file served per day.
Example:
11/15/2009: file1 1,000 file2 2000 file3 3000
Logs are very large, 2GB+
Project needs to be completed in 1-2 days.



