I never found a good way to deal with SQL dumps (like from mysql or where ever) because the really big ones were to slow to load or query (if they ever loaded in the first place).

The simplest choice seems to be this utility:
https://github.com/dumblob/mysql2sqlite

It converts the mysql dumps to SQLite and I just use the sqlitebrowser to view the data or do queries. The conversion takes a while but afterwards I can view in a graphical browser the tables.

Converting to CSV never works right
Loading into a MySQL or other database takes too long
viewing it in an editor (like vi or nano) doesn't work and can look terrible onscreen

Does anyone have anything better? Or is this the bees knees?

Emeditor bro, its very useful for the large ones

(June 1, 2022, 05:11 PM)TarTarX Wrote: Emeditor bro, its very useful for the large ones

Looks like a Windows app. But it won't be just one file to open.

I think the use case is:

1) find the email address of your sworn enemy and see what dumps they're in (amIpwned.com)
2) download all those breaches/dumps/combolists they appear in
2.5) simplify by flattening out the files (not *.sql) into CSV or 1-row-per-record TXT files
3) go through them ALL and find only that email address, passwords or hashes (and pipe into a file) of your sworn enemy
4) try to uncover the passwords (hashcat to dehash) after creating specific wordlists (% cupp -i ...etc) and hashcat rules (%hashcat -r 64rules...etc)

I mean, if you're going after your sworn enemy to mess up his Netflix preferences, you need to do it like a professional!

This is dope useful, going to try it out on some data sets, appreciate you!

Thanks you