Finding an OS solution for parsing MySQL databases
Our company is trying to find an open source solution that we could use to better parse our MySQL databases. We would like to be able to scan, search and sort log files down to a single event using keyword search function. Lastly we would like the ability to export this data into Excel format or a comparable format. What would you recommend?
MySQL Administrator does provide functionality for searching the log files for keywords and saving to a text format which could be imported into Excel.
You may also find the Practical Query Analyzer project to be of use. It is a multi-database query log analyzer that can identify trends in your logfiles.
This was first published in April 2006