Updated: 02/04/2006

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).

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • GPL,
  • LGPL
• Author
  • Steve Hannah