Tag Archives: mySQL

08 Mar 2009
How to list comment spam IP addresses

By hornlo | Published 2009-03-08

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

By hornlo | Published 2008-07-06

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: , , ,
Comments Off

Site last updated 2012-01-25 @ 15:14:10