Ask the Expert

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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: