server inventory import

[dwcasey]

What is the best way to import a CSV file into MySQL? Are there tools available to assist in this?

Once in there, is there anything similar to msaccess to run queries, generate reports, etc?

We were looking at bringing this into MSAccess, but I started thinking if we put it in MySQL, it would be available to more folks, and we could possibly put a web front-end to query the data.

 

[elsenorjose]

Loading data from files:

http://dev.mysql.com/doc/refman/5.0/en/load-data.html

There are no built-in tools like Access Reports or Forms, but as you mentioned, web front end is a very common interface. Most people use PHP when developing front ends for MySQL.