How to parse 10GB SQL File ? as email:pass

Discussion in 'Cracking Discussions & Help Forum' started by adores, Apr 27, 2016.

  1. adores

    adores Basic Member

    Messages:
    49
    Likes:
    0
    Ratio:
    0
    Hey guys , I bought mate1.com full DB @ deepweb. It's about 10 GB. I downloaded MySQL server , tried to import DB in MySQL but it takes fucking long. Also tried with the text editors ( UltraEdit , Delimit etc. ) editors don't show as columns. All I want to do is extract as email:pass format. Is there any script for windows ? I am stucked. Need help of experienced users.



    Example DB view below.

    INSERT INTO `Profile` VALUES (1119979,4,0,'0001-01-01 00:00:00',13,1,'NEW',1,25554,3,231,'1970-12-26',1,3,1,'[email protected]',4,1,'Kenneth',2,0,'1969-12-31 19:00:00',0,1,182,0,1,1,'2003-05-20 15:10:46','Sanders',38.6307,-92.5672,'1969-12-31 19:00:00','',0,'krscalmo',1,'soiltiny34',1,1,'65018',36,1,3,2,-1,'2008-04-09 06:41:00',1,'','2003-05-20 15:10:46',4,'I\'M Swm Looking For Sf',1,1,'2009-03-04 20:31:55',1,1,1),(1119980,4,0,'0001-01-01 00:00:00',6,1,'NEW',8,1,3,110,'1963-06-09',1,7,1,'[email protected]',4,1,'Gian Maria',2,0,'1969-12-31 19:00:00',0,1,187,0,1,0,'2003-04-02 07:46:32','Tirelli',-1000,-1000,'1969-12-31 19:00:00','',0,'giansen',1,'tipoak87',1,1,'',1,1,3,2,-1,'2008-04-09 06:37:46',1,'','2003-04-02 07:46:32',5,'& love I Put Only To Increase Demand',1,1,'2003-04-02 12:46:32',1,1,1),(1119981,5,0,'0001-01-01 00:00:00',9,1,'NEW',5,29334,5,231,'1937-09-21',1,4,1,'[email protected]',4,1,'',2,0,'1969-12-31 19:00:00',0,1,172,0,1,0,'2003-01-30 09:45:23','',43.2038,-70.8778,'1969-12-31 19:00:00','',0,'slivers4',111,'hipdill68',1,1,'03820',45,1,3,2,-1,'2008-04-09 06:33:39',1,'','2003-01-30 09:45:23',5,'Untitled',1,1,'2009-03-04 20:31:55',1,1,1),(1119985,1,0,'0001-01-01 00:00:00',9,1,'NEW',1,12091,1,231,'1937-09-21',1,1,1,'[email protected]',1,1,'',3,0,'1969-12-31 19:00:00',0,1,121,0,1,0,'2003-06-01 09:12:32','',27.9679,-82.518,'1969-12-31 19:00:00','',1,'seamus11',1,'carpnavy44',1,1,'33650',17,1,3,1,0,'0001-01-01 00:00:00',1,'','2003-06-01 09:12:32',1,'Untitled',1,1,'2014-04-06 09:57:10',1,1,1),(1119987,3,0,'0001-01-01 00:00:00',8,1,

    [​IMG]
     
  2. M95

    M95 Member VIP

    Messages:
    674
    Likes:
    64
    Ratio:
    0.04
    If I'm right there are tools for this, will keep my eyes open
     
  3. cust

    cust Basic Member

    Messages:
    32
    Likes:
    5
    Ratio:
    3.83

Share This Page