Home > mSQL, Perl/CGI, Python, System Administration > Backup Logs Store In Mysql

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.


Backup Logs Store In Mysql

Comments are closed.
Bear