4

I've got an IIS site running with a MySQL db. Is there a way to get logparser to export into a MySQL database?

Glenn Slaven
  • 33,720
  • 26
  • 113
  • 165

2 Answers2

1

Since LogParser can output CSV and most databases should be able to import from a CSV file, this should be possible. I'm not that familiar with MySQL but I found a thread on the iss.net forums which discusses how to do this:

http://forums.iis.net/t/1166385.aspx

"...try... outputting data as CSV and then using MYSQLIMPORT to get the data into MySQL."

Luke Girvin
  • 13,221
  • 9
  • 64
  • 84
0

The "SQL" output format dumps results to any ODBC-compatible database. You can see its options by using the following command:

LogParser -h -o:SQL
Gabriele Giuseppini
  • 1,541
  • 11
  • 19