Problem solve Get help with specific problems with your technologies, process and projects.

Finding an OS solution for parsing MySQL databases

MySQL expert Mike Hillyer recommends two open source programs that deal with the export, scanning, searching and sorting od data.

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.

Dig Deeper on Linux servers

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.