navigate

categories

Don’t Mark SPAM as SPAM!

Backing up your blog database is a smart thing to do. In fact it’s recommended by every administrator on the planet. Regardless, I haven’t done the chore in weeks. Today I realized my lack of emergency precaution and freaked myself out. So I logged on to phpMyAdmin as hurried as I can to export my database for download. Guess what it was 4mb at least, and I thought I haven’t been blogging much around here. I suspected bogus and there it was buried under. It turned out all these time marking SPAM as SPAM in WordPress ended up storing them in my database instead of banishing them to datahell. So there I was with 7000+ comment SPAM entries spinning the brains off my head. Thank heavens for phpMyAdmin and it’s intelligent search and destroy feature (yeah I made that up!) my database is now back to 1mb and that makes me a happy blogger.

Good night! (South East Asian time)

6 comments on “Don’t Mark SPAM as SPAM!”

  1. cityfist says:

    I suck at teh interw3b. I don’t even know what a blog database is.

  2. JErm says:

    That’s fine you use blogspot they take care of everything for you! :)

  3. Jaime says:

    Only 2MB, you need to blog more :P Truthfully I don’t even know what my database size is, Blogsome takes care of it, and does regular backups :)

  4. JErm says:

    I have 460+ posts.. that’s plenty for a guy like me! Blog databases shouldn’t be huge. I like nice and small! :D

  5. Extremelee says:

    So where do you find these spam entries? I’ve not backed up any of my databases in ages. Not even my urbanskaters site. Can’t be bothered, to unhappy right now. Even found out that I can’t upload using the wordpress upload feature anymore, dunno, can’t be bothered.. blah blah blah….

  6. JErm says:

    Nothing can touch you uhh Lee? How about I sock you in the face? Will that do it? Will that get you to backup your databases?? :-P

say something...