Taking Chances with Ones and Zeroes

September 16th, 2008

I just went into a live online database via PHPMyAdmin and deleted 22,000 spam comments from a client’s WordPress blog all at once. That’s the first actual database operation I’ve ever done! Scary, even with a backup. Not that I want to make a habit of it — too much potential for destruction. But I can now claim to have executed a command that looks like this:

SELECT *FROM wp_comments WHERE comment_approved =”0″
delete from wp_comments WHERE comment_approved =”0″

And lived to tell the tale. Thanks to this guy for the instructions.

cpd

Bookmark and Share

2 Comments Add your own

  • 1. Tiffany de Lisio  |  September 17th, 2008 at 8:31 am

    can you explain how to post an article/.pdf on a website via wordpress or server? I also wondered is there is a way to layer pages rather than blog. If this is cutting into your income generating secrets, no worries, just asking. : ) I give free legal information all the time and people still need lawyers… hah!

  • 2. cpd  |  September 17th, 2008 at 11:23 am

    Hey Tiffany, it depends on which HTML editor is built into the version of WordPress you use. The default editor is a bit of a pain, so I’ve been using a ($50) editor called WysiwigPro 3 on client sites lately — it handles images and files well, and also cleans up the crappy code that comes out when you paste something from Word.

    For instructions using the default editor, try this. BTW, on e.politics I run it old-school — FTP the docs up and link to them in the code. Helps keep those mad HTML skillz fresh.

Help build e.politics

Make a comment, correct my errors, suggest more tools and tactics, leave a case study, or otherwise make this page a better resource.

Required

Required, hidden

Some HTML allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Trackback this post  |  Subscribe to the comments via RSS Feed


Bookmark and Share

Follow Epolitics.com

Follow Epolitics.com on Twitter    Follow Epolitics.com on Facebook     Follow Epolitics.com on Twitter

Email updates (enter address)


SEARCH EPOLITICS.COM


Epolitics.com EBooks

NEW!

Download Winning in 2012 Ebook Download Learning from Obama

Recent Highlights

Epolitics.com Classics

Calendar

September 2008
S M T W T F S
« Aug   Oct »
 123456
78910111213
14151617181920
21222324252627
282930  

Most Recent Posts

home about contact colin delany put e.politics to work