Jump to content

Topic on Extension talk:Access Log/Flow

How to get a .csv or similar dump

1
Fustbariclation (talkcontribs)

I'm finding this a very useful extension, for all sorts of reasons. What I'd like to do is get the last month's worth of access log in a flat file so I can do my own analysis. I'm running on a hosted server, which times out if the access log program runs too long. I can get there by going through it 500 lines at a time, but it's quite a tedious solution.

I've looked at the database table:

tw_log_id tw_log_timestamp tw_log_user tw_log_username tw_log_namespace tw_log_title tw_log_action

Naturally, these keys are binary, pointing to the actual name, action and so forth, and the timestamps are encoded. I don't know enough SQL (I don't know any, to be more precise), to know how to set up a query to return what turns up in the access log.

So, I was just wondering, if there was a handy sql query lying about that I could use - if so, I'd be most grateful.

The other solution would be to mess about with the access log program - it might not be too difficult if all I did was to put in a sleep every hundred or so queries to stop the server stopping it, but I think that a SQL query would be a more sensible solution if I had it.

Any other suggestions gratefully received.

Reply to "How to get a .csv or similar dump"