Tag Archives: mySQL

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 … Continue reading

Posted in meta | Tagged , , | 1 Comment

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 … Continue reading

Posted in programming | Tagged , , , | Leave a comment