Tag Archives: mySQL

08 Mar 2009
How to list comment spam IP addresses

As sort of a followup to my Comment Spam post, here’s a quick way to get a list of spammers to deny via your .htaccess file (or whatever method you chose to ban IP addresses). First, the SQL statement to get the list; put it in a file called list-spammers.sql: SELECT count(comment_author_IP) AS 'Count', comment_author_IP […]

Category: meta
Tags: , ,
1 Comment

06 Jul 2008
MySQL Backups

Even if you consistently back up your filesystem, you should also back up your databases separately, using an appropriate tool to maintain their relational integrity and to provide for recovery independent of the filesystem. MySQL is a pervasive, lightweight RDBMS that is used with popular applications such as WordPress and Bugzilla. The mysqldump utility which […]

Category: programming
Tags: , , ,
Leave a comment

Site last updated 2019-08-10 05:50:54