Application for extracting data from MySql

jakobverner · 10-09-2007, 01:42 AM

I need to extract data from a MySql database to Excel, Spreadsheet, or maby just to a csv-format.

The data that i am going to extract is network monitoring data, and the point is to be able to generate day/month/year-statistics of uptime for multiple servers.

Any suggestions?

I am not going to use phpMyAdmin since the documentation for this is...

kstan · 10-09-2007, 02:35 AM

Hi jakobverner,
The most simply way is install myodbc driver in your windows computer, then start Microsoft Excel to pull data directly from odbc.

Regards,
Ks

jakobverner · 10-09-2007, 02:52 AM

Would it then be possible to konfigure that myodbc-thing to connect to a remote mysql-server and extract the data to Excel on a local windows-machine?

jakobverner · 10-09-2007, 03:31 AM

Okay, I can see that this is my solution, since it is possible to connect to a remote MySql-server and import data to Excel.

Thanks for your help

kstan · 10-09-2007, 03:39 AM

yes, when you save the excel document, you have a option to refresh data, manually/automatically and etc. It's very powerful.
We personally use this method to extract data from production mysql server, and we can simply input some parameter into few cell for filtering purpose.