Trackback Spamlog aufgeräumt

Sunday, June 24. 2007

Trackback Spamlog aufgeräumt

Wer schon Trackback Spam aufräumt, sollte nicht das dazugehörige Log vergessen. Wäre mir nichtmal aufgefallen, wenn ein DB Dump nicht so groß geworden wäre.

Also das Trackback Spamlog aufräumen:



mysql> delete from serendipity_spamblocklog where timestamp < (UNIX_TIMESTAMP() - (86400 * 7));

Query OK, 243696 rows affected (1 min 15.17 sec)

Posted by Alexander Koch in Technik at 23:35 | Comments (0) | Trackbacks (0)

Defined tags for this entry: blog, s9y

Trackbacks

Trackback specific URI for this entry

No Trackbacks

Comments

Display comments as (Linear | Threaded)

No comments

Add Comment

Name
Email
Homepage
In reply to
Comment	Enclosing asterisks marks text as bold (word), underscore are made via _word_. Standard emoticons like :-) and ;-) are converted to images. To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly. Enter the string from the spam-prevention image above:
	Remember Information?