Category: PHP Script Codes > MySQL Log Parser
This a is a simple PHP command line utility that will parse a MySQL update log file and dump only updates to a particular database in a certain time interval. Currently there are no flags, you are prompted for all input. Usage:

bash-2.05$ php mysql_log_parser.php Enter the path to the log file to be processed:/path/to/update log.nnn
Enter the name of the database to extract:MyDB
Start Time (T= current time - your input here):864000
End Time (T = current time - your input here):35000
Enter the path to the output file:output.log

This would output the all update statements on the MyDB database during the time interval (864000 seconds ago, 35000 seconds ago).