MySQL Log ParserHits: 19
*****
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).
Platform(s): n/a
Date: Feb, 04 2006 Author: Steve Hannah, http://www.sjhannah.com/blog/?page_id=27 {
License}
{
Ratings}Number of Ratings: 0 Votes
Visitor Voting Booth:
{
Others Scripts}
|