1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Extract emails from a large SQL file.

Discussion in 'Black Hat SEO' started by worldismine, Jan 5, 2010.

  1. worldismine

    worldismine Regular Member

    Joined:
    Feb 25, 2009
    Messages:
    380
    Likes Received:
    286
    Im having a problem. Ive got a 1.7 gb mysql file and I need to dump the email column out of it. The file is so large that its crashing my email extractors... Can anyone recommend a good one? Ive googled for hours and tried multiple proggys with no luck.
     
  2. pavan

    pavan Elite Member

    Joined:
    Mar 30, 2008
    Messages:
    1,603
    Likes Received:
    432
    upload you file to your sql server and just extract the email column
     
  3. pyronaut

    pyronaut Executive VIP

    Joined:
    Dec 9, 2008
    Messages:
    1,229
    Likes Received:
    1,422
    What he said :p.

    Is it a MYSQL file or Transact SQL.

    I dunno whether MySQL can handle that kind of size. Microsoft SQL server should handle it fine though. Then you just have a simple "Select" statement to go.
     
  4. embersion

    embersion BANNED BANNED

    Joined:
    Jun 13, 2009
    Messages:
    430
    Likes Received:
    15
    it can be done by your system too.. intall xampp and inport and and export field of emails

    tht's easy
     
    • Thanks Thanks x 1
  5. worldismine

    worldismine Regular Member

    Joined:
    Feb 25, 2009
    Messages:
    380
    Likes Received:
    286
    Thanks man !!