Manual talk:Logging table

Is there a page dedicated to documenting the Special:Log interface? Jayvdb 02:33, 4 July 2007 (UTC)

I am also looking for this documentation ... --77.110.20.135 08:40, 28 September 2009 (UTC)

Me too... Tisane 01:30, 22 March 2010 (UTC)

What do you mean with "interface"? What in this interface is not to understand? Do you actually mean the API? --88.130.74.254 21:26, 19 February 2014 (UTC)

Explain...

Explain what do 'create', 'create2', etc, mean, please. Emijrp 22:23, 21 January 2011 (UTC)

"create" means "user was created", "create2" obviously means "a registered user(!) has created a user (= an additional user to the one he currently uses)". In the last case you most probably see an admin or a spammer. --88.130.74.254 21:25, 19 February 2014 (UTC)

Is clearing this table safe?

Is it safe to clear the contents of the log table? --Frug (talk) 16:53, 28 October 2013 (UTC)

No. You will lose every block and edit reasons. --Bachsau (talk) 17:01, 28 October 2013 (UTC)

Err, not quite. Blocks are stored in the ipblocks table and edit (action=edit) summaries are stored in the revision table.

That said, you probably shouldn't clear the contents of the logging table. Why do you ask? --MZMcBride (talk) 01:37, 29 October 2013 (UTC)

Sometimes one might want to redact, with extreme prejudice, a large number of log events. Leucosticte (talk) 02:12, 29 October 2013 (UTC)

The logging table contains "only" log information. Basically everything you can see on Special:Log is coming from there. However, as far as I see, it does not contain information, which are actually relevant for how MediaWiki works: E.g. when you remove the logging message that a page had been deleted, you will no longer see this message and when you remove the logging message that you moved a page, you will no longer see that message. However, the page will still be deleted (and be restorable and so on as usual) and the moved page wil still be moved. So you can remove the contents of the logging table, but your wiki will after that behave inconsistently in that way as it will no longer show these (old) messages, where it normally would show them. --88.130.74.254 21:23, 19 February 2014 (UTC)

Query specific rights change

I was wondering if it is possible to query logging table for a specific change in permissions. For example: query all grant/revoke of sysop group (it is particularly important to distinct grants and revoke actions). My objective is to make a report of the number of sysops per month across the time. Is this feasible? Or maybe I can find somewhere else the startDate/endDate a user belongs to a group? --Diego Queiroz (talk) 19:20, 7 July 2017 (UTC)

Is there a SQL dump of this table?

If for reasons like "certain rows contains sensitive user data", can we have a sanitized dump?

Thank you!

Xinbenlv (talk) 01:37, 5 February 2020 (UTC)