[eterloop]

Grep in shell (Linux/Mac)
findstr in command line (Windows)

[blackboar]

I just downloaded wattpad database, which is 120 gb sql file. When I open it, i cannot use crtl+f to find someone because data is too big and my software is crashing. Do you know how can I find the data that I am looking. Which software should I use (Linux machine)? or any other way for me to read the sql file.

Import it into a database and then index the main Email or Phone or User fields that you find useful.

cat FILE.sql |mongoimport --type csv -c wattpad -d wattpad --fields a,b,c,d

Maybe use perl, sed, awk to clean up the sql file first.

[remmr]

I just downloaded wattpad database, which is 120 gb sql file. When I open it, i cannot use crtl+f to find someone because data is too big and my software is crashing. Do you know how can I find the data that I am looking. Which software should I use (Linux machine)? or any other way for me to read the sql file.

Import it into a database and then index the main Email or Phone or User fields that you find useful.

cat FILE.sql |mongoimport --type csv -c wattpad -d wattpad --fields a,b,c,d

Maybe use perl, sed, awk to clean up the sql file first.

i just split the file into smaller pieces and it worked well. Thx for your help anyways

[blackboar]

I just downloaded wattpad database, which is 120 gb sql file. When I open it, i cannot use crtl+f to find someone because data is too big and my software is crashing. Do you know how can I find the data that I am looking. Which software should I use (Linux machine)? or any other way for me to read the sql file.

Import it into a database and then index the main Email or Phone or User fields that you find useful.

cat FILE.sql |mongoimport --type csv -c wattpad -d wattpad --fields a,b,c,d

Maybe use perl, sed, awk to clean up the sql file first.

i just split the file into smaller pieces and it worked well. Thx for your help anyways

Sure that works. Until you have 10 or so of the top biggest breaches and then your hdd slows to a crawl whenever you grep the files...

Indexing is a gift from God. Don't spit in his face.

[joepa]

grep "yoursearchkey" wattpad.txt

[notaANON]

If you are using windows you can download large text viewer from microsoft store. its what i use to check those database.

This forum account is currently banned. Ban Length: Permanent (N/A Remaining)
Ban Reason: Leeching | https://breachforums.rs/Forum-Ban-Appeals if you feel this is incorrect.

[red_dot]

you should try 010editor
https://www.sweetscape.com/010editor/

[darkphoenix24]

use glogg or hxd, personally using hxd cause it has low memory usage

[blackboar]

Weirdly the easiest way to get unix commands in windows was using Git tools but I can't seem to find them anymore

Here's a summary of other possibilities:
https://stackoverflow.com/questions/3519...er-windows