12x GPU Monster For SALE by HashKiller Owner

NOTE: Why not use our List Manager to crack your lists? Its easy and enables better management.

NOTE: When cracking WPA/WPA2 passwords, make sure you check gpuhash.me first incase it's already been processed.

Home - General Discussion - How to take only the hash on a large dump.


7 Results - Page 1 of 1 -
1
Author Message
Avatar
Naix

Status: n/a
Joined: Wed, 28 Sep 2011
Posts: 26
Team:
Reputation: 1 Reputation
Offline
Wed, 28 Sep 2011 @ 00:29:31

INSERT INTO `users`(`uid`, `username`, `password`, `privilege`, `fname`, `email`, `phone`, `local`, `signdate`, `activedate`, `ratingdate`, `inboxnew`, `inboxtotal`, `ratingsnew`, `primeflag`, `primedate`, `primespan`, `status`, `statusuid`, `end`, `start`, `lastip`, `pmblock`) VALUES ('8527', 'user12345', '760cd2b8bbab6c658dac03c28b03c376', 'user', 'Humdinger', 'user123454@yahoo.com', '92248652569278917282', 'Paranaque', '2004-01-18 10:41:55', '2008-09-10 23:34:20', '2004-12-09 13:02:50', '1', '0', '0', 'n', '0000-00-00 00:00:00', '0', 'active', '0', '', '', '124.106.198.140', '0');

here is one of the example of the data, and i would like to take only the hashes but it was a very huge lot of hashes on it, approx 700,000 users on it. hope someone could help me out, or if there any software to use. thanks in advance.


Avatar
SmilingWolf

Status: n/a
Joined: Tue, 23 Aug 2011
Posts: 90
Team:
Reputation: 27 Reputation
Offline
Wed, 28 Sep 2011 @ 13:52:00

On Linux:
grep -e "[0-9a-f]\{32\}" backup.sql > backup.hash


Avatar
Naix

Status: n/a
Joined: Wed, 28 Sep 2011
Posts: 26
Team:
Reputation: 1 Reputation
Offline
Thu, 29 Sep 2011 @ 03:50:16

@SmilingWolf i tried your command on linux but it doesnt works.


Avatar
SmilingWolf

Status: n/a
Joined: Tue, 23 Aug 2011
Posts: 90
Team:
Reputation: 27 Reputation
Offline
Thu, 29 Sep 2011 @ 13:34:43

My fault, I forgot to put the -o switch in the command to tell grep to display only the matching part, not the entire string.
This is the correct command:

grep -o -e "[0-9a-f]\{32\}" backup.sql > backup.hash


Avatar
Naix

Status: n/a
Joined: Wed, 28 Sep 2011
Posts: 26
Team:
Reputation: 1 Reputation
Offline
Sat, 01 Oct 2011 @ 17:58:00

thanks smilingwolf


Avatar
Neusbeer

Status: Member
Joined: Sun, 18 Sep 2011
Posts: 112
Team:
Reputation: 40 Reputation
Offline
Sat, 08 Oct 2011 @ 23:18:38

I'm busy doing some experience on those nice linux commands.

I use
grep -o -e "[0-9a-f]\{32\}" shop_users.sql > userhash.txt

after that:
sort userhash.txt | uniq -u > userhash_sorted.txt


any additional tips?


Avatar
proman

Status: n/a
Joined: Fri, 07 Dec 2012
Posts: 3
Team:
Reputation: 0 Reputation
Offline
Fri, 07 Dec 2012 @ 21:02:29

i have 1 diffrent suggestion how to split column in mysql db, i hope this help you.

1. install xampp or whatever apache phpmyadmin softwares and insert or upload db you have been dumped (local)
2. login into your target db server via shell, phpmyadmin or whatever can you login in db server (online)
3. use this sql cmd for split data whatever you need:
SELECT password FROM `users` LIMIT 0,99999999

if you want add another column just add column name, exp:
SELECT email,password FROM `users` LIMIT 0,99999999

sorry with my bad english, thanks



7 Results - Page 1 of 1 -
1

We have a total of 201936 messages in 24884 topics.
We have a total of 22192 registered users.
Our newest registered member is John:Smith.