How to extract emails from data base ….. ?

  • Hi …

    I wnat to collect all the emails from my wp database.

    I am intending to send a newsletter concerning my blog to these emails.

    I don’t have neither authors nor users in my blog. These emails are shown in my database through the comments.

    I tried with success to extract these emails (after i downloaded my database and converted it to a doc file) using some softwares , but the problem i can’t collect all these emails in one file because these softwares are a demo version.

    I have about 900 emails in my database.

    Is there any method to extract these emails in one file ?

    THANKS

Viewing 15 replies - 1 through 15 (of 20 total)

  • Running this query in your favourite MySQL client will do it:

    select distinct comment_author_email from comments

    However, I think you need to careful here and make sure your email to them isn’t interpreted as spam, which I’m sure they won’t appreciate, even if there is a hint of “marketing” in the contents.

    Thread Starter Rasheed Bydousi

    (@rasheed)

    thanks pizdin

    i found a solutions finally-

    Title : Extract Emails
    Target OS : All Windows
    Copyright : Ixis Research, Ltd
    Email Address: [email protected]
    Home Page: https://www.getfreefile.com/mailhunt.html
    Download Program: https://www.getfreefile.com/download/mailhunt.zip
    Software Type: Freeware

    hope this help others

    with regards

    Just one more example of a reason not to use real emails OR register on sites. sigh.

    What if the comment form is clearly telling people that they may get a one-off mailing? Which it should do, of course.

    “Which it should do, of course.”

    You expect this to happen? Yeah right.

    “You expect this to happen?”

    Yes, absolutely. You obviously have a different set of experiences, and that’s ok.

    ? Yeah. My experience is that those who rape databases for email addys not only don’t say that up front, they don’t say that anywhere.

    YOU obviously have a different set of experiences – from 99% of the email-addy providing world. Which is why I use one umbrella email on one domain of my own for everything which is likely to drop spam unrelenting – 99.99% of anything I do anywhere, including here.

    Some seemingly concrete numbers there, vkaryl. Where did you get that 99% figure from? It seems rather extreme but I’d love to read up on it.

    So who’s is bigger?

    Who’s is bigger what? If you’re talking about the percentages, I doubt we can get any bigger than 99%, can we?

    “So who’s is bigger?” thats a hint to you two, i think — typically that would be asked of 2 men that were comparing .. ermm, ya knows.

    Ill pipe in though and say that I have NEVER come across a blog site that was up front about any harvesting of emails, if such harvesting ever occurred.

    I’ll say one other thing pizdin, also — I dont believe people are generally honest about much, if they can get away with being dishonest. Given that there isnt enough reward in telling a casual blog commenter that their email might be fished out of the db at a later time, the typical dishonest site owner is just going to grab them without telling you/me/us. The email addy is the reward they want, after all.

    I dont like that, and I believe it goes on. more than we realize. email addresses are GOLD to marketers, after all.

    —

    heres an interesting thread:

    https://www.ads-software.com/support/topic/70826?replies=17

    Pizdin_dim – “Who’s is bigger” was a direct quote from another thread you were involved in yesterday.

    “typically that would be asked of 2 men that were comparing .. ermm, ya knows.”

    I’m offended. You’re have obviously assumed I’m a man. How presumptuous of you!

    “‘Who’s is bigger’ was a direct quote from another thread you were involved in yesterday.”

    A direct quote? Huh? I’ve scoured my threads from yesterday and I can’t find the words “who’s is bigger” anywhere. Are you confusing me with someone else perhaps?

    EDIT: I’ve just done a forum search and can’t find it, although a search for “bigger” DID produce over 600 results. Which one were you talking about?

    *sigh* pizdin_dim, here: https://www.ads-software.com/support/topic/83831

    I posted that because the sniping was all too much like what whooami indicated above. If you’re not male, fine. How about not doing the “mine’s bigger than yours” stuff, then? Just make your points without a lot of hot air and blather, okay? Then no one will assume you’re a very young male who’s peacocking…. and I use that term advisedly.

    [Edit: as far as percentages, I’m not about to reveal sources. I don’t see any point in helping rapers to the goal. YOU figure it out.

    And thanks whoo….]

Viewing 15 replies - 1 through 15 (of 20 total)
  • The topic ‘How to extract emails from data base ….. ?’ is closed to new replies.