Hey /g/ I need help with something. I have a 6gb .sql file that i want to read. How would I go about that? A bit of googling led me to mysql addon for excel but i couldnt get it to work. Im sure some of you guys know this stuff well. Thanks in advance
Just dump the sql into some sql server.
And wait a few hours/days :v
Who the fuck saves files as blobs into sql anyway
>>53893399
How do i get a sql server
You could read it into a .db file, look at the schema, and from the schema you could output individual tables into smaller txt files or sql files
I gotta ask though, why do you want to look at a .sql file, a 6gig one at that, why not use the language to look at exactly what you need
>>53895023
Idk how to read it into db file and idk how to read it in language. Im not a /g/ commoner could you explain in simpler terms
Lol op downloaded the Turkish SSN dump
>>53896724
Yes how do i use it i want to check if its real
A .sql file is plain text. Open it in your favorite text editor if you want a look-see at what's there.
Level Up by using this as an excuse to install a SQL server and restore the database and run queries against it.
Good luck, Erdogan.
>>53897029
Notepad++ says too big so does notepad
Is there any stronk text editors?
>>53897207
Yes, use vim
Most common last names from the db.
mernis=> select count(*), last from citizen group by last order by count(*) desc limit 50;
count | last
--------+----------
708292 | YILMAZ
488372 | KAYA
461717 | DEMIR
404113 | SAHIN
398952 | CELIK
389222 | YILDIZ
384801 | YILDIRIM
358902 | OZTURK
356395 | AYDIN
330009 | OZDEMIR
293448 | ARSLAN
279587 | DOGAN
246588 | KILIC
207553 | CETIN
207072 | ASLAN
169501 | KARA
167033 | KOC
161072 | KURT
156014 | OZKAN
148693 | ACAR
146472 | OZCAN
146382 | SIMSEK
144710 | CAKIR
143297 | KORKMAZ
142700 | ERDOGAN