drupal

The day came when Awstats reported 300 visits / day and Google Analytics reported just a couple of visits / day. So, what's happening? Well, not much except for the 3000 comments on http://jonas.granvik.me/blog/eclipse-user-variable. There sure are lots of people interested in Eclipse variables...

I removed the spam with DB queries directly, since Drupal's default interface for removing comments is quite ineffective for large quantities. The next day, again, the comments were flooded with spam.

Just a quick note which took me some time and advice asking to find out. I have a database with two drupal installations separated by a table prefix, say drupal1_ and drupal2_. Lets call my database simply myDB.

If I'd like to backup only certain tables to an SQL file using mysqldump, I'd have to list all the table names separately. This is not nice at least since module installations and upgrades might add prefixed tables to the database dynamically over time. The other catch is that I want to do this without PHP.