All geek questions in one place

Can I run LogParser 2.2 for export to MySQL?

I have an IIS site working with MySQL db. Is there a way to get logparser to export to a MySQL database?

+4
source share
2 answers

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

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

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

+1
source

The "SQL" output format outputs the results to any ODBC compatible database. You can see its parameters using the following command:

LogParser -h -o:SQL
0
source

Source: https://habr.com/ru/post/1305625/

More articles:


All Articles