Buying Extract Emails from Database

Discussion in 'Programming' started by schroe9, Sep 14, 2010.

  1. #1
    There is a row within the tables of the DB located in phpmyadmin that has all email addy's

    I need these extracted in CSV format with no more then 2,000 per file

    There is a total of 13,100 emails


    PM me with how much you would like to charge to do this.
     
    schroe9, Sep 14, 2010 IP
  2. kogee4

    kogee4 Peon

    Messages:
    38
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    hello,
    please check your pm´s.
    thanks,
    kogee4
     
    kogee4, Sep 14, 2010 IP
  3. arunsinghrawat

    arunsinghrawat Greenhorn

    Messages:
    17
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    11
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    Hello,
    I am a PHP developer.I go through your message and ready to work on this now.$50 is charge for this.
     
    arunsinghrawat, Sep 14, 2010 IP
  4. stephan2307

    stephan2307 Well-Known Member

    Messages:
    1,277
    Likes Received:
    33
    Best Answers:
    7
    Trophy Points:
    150
    As Seller:
    100% - 0
    As Buyer:
    100% - 2
    #4
    You can do this yourself.

    Go to the table where the emails are in. Then click on the SQL tab and write the following query

    SELECT `FIELDNAME` FROM `TABLE`
    Code (markup):
    (replace FIELDNAME with the field where the email addresses are in like email or so and TABLE with the table name)

    You should see then only the email addresses. Then right at the bottom of the page there is a section called "Query results operations". Click on the export option.

    On the next screen select one of the csv options depending on what you want.

    Finally scroll to the bottom and click the Go button. Save the file and you are done.
     
    stephan2307, Sep 15, 2010 IP
  5. tanmoy1981

    tanmoy1981 Member

    Messages:
    33
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #5
    Please contact me if the job is not done yet.
     
    tanmoy1981, Sep 15, 2010 IP
  6. SEOaaron

    SEOaaron Peon

    Messages:
    107
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #6
    Lets imagine your database is called database, and your table is called table. For example sake, your emails row will be called emails.

    SELECT 'emails' FROM 'database.table' LIMIT 2000
    Code (markup):
    Then export as CSV as posted above

    Then, follow this pattern to get the rest

    SELECT 'emails' FROM 'database.table' LIMIT 2000, 2000
    Code (markup):
    SELECT 'emails' FROM 'database.table' LIMIT 4000, 2000
    Code (markup):
    SELECT 'emails' FROM 'database.table' LIMIT 6000, 2000
    Code (markup):
    etc.
     
    SEOaaron, Sep 15, 2010 IP
  7. kishore415

    kishore415 Well-Known Member

    Messages:
    1,462
    Likes Received:
    41
    Best Answers:
    0
    Trophy Points:
    160
    As Seller:
    100% - 0
    As Buyer:
    25.0% - 1
    #7
    Job completed ..thanks
     
    kishore415, Sep 16, 2010 IP