MRTG and Database

Does anyone knows how to pipe MRTG log data into a database using a Window system? Thanks in advance.

Daniel

What format can you export your MRTG data in?

As for now, any format will do

Daniel

Then you can use the mysqlimport utility or Load data infile syntax as well. You will need to create your table structure in MySQL before loading the data.

Thanks Victor,
I have had experience with mysqlimport. What I trying to get is with MRTG, the log files are must some numbers written in columns. I am not sure how I will be able to generate these numbers into graphs that appears as it is right now on my webserver. I just don't want to store all the data in a database that I can only spit numbers out instead of the graphs I need. If you have had experiences with doing this, I would really appreciate your help. Thanks again.

Daniel

I do not use MySQL to store my MRTG data. I use a combination of off the shelf products to analyze and graph this data. What is the purpose of migrating the MRTG data? MySQL does support curves and GIS.
http://www.mysql.com/doc/en/GIS_class_curve.html
...
Are you looking for a front end that will produce the graphs for you?

Thanks Victor,
I am sorry for not being too clear about what I wanted to do. Here is what I am hoping to be able to accomplish.

Currently I am analyzing inErrors&outErrors and bandwith on a cisco switch. I created an index page for in&outErrors and another for bandwith. So at the moment, I am only able to either bandwith or errors for that switch, but NOT both at the same page. So, if I am able to pipe all these data into a database. That way I when I querry for a port on that switch I will be able to see bandwith, in and out errors for that port on a singe webpage. I am not sure if I can do this or not, but it would be nice. Again, I really appreciate all the comments you have provided regarding my problem Victor.

Daniel

Have you looked at RRDTool.

URL

I personally, have not used it, but will soon.