SQL Need Help on extraction of data from Large MySQL db to excel

[edward0666]

Can someone please share an working mehtod to Extract data from large MySQL or any other SQL leak dumps, so that we can properly structurized the data in excel or any other spreadsheet format for proper use. As i have a leak dump of MySQL sized around 14 Gb i tried to load it on several software no luck only getting error, after that i splitted the file in 50mb size now i can open it and see the code but once i try to execute or type export data on excel it not working. The main problem is that with Query code we i cant structure the data with the help of any editor or emeditor , if i try to do so i lost the details which column or row belongs to where ? does anyone faced this same complications before ?

Do like to hear you opinion here.

My TG @eddykroger

 

[zLeak3r]

You are free to use "Navicat" software. It's easy to export multiple file types on navicat.

 

[pupkin24]

try sequel pro on mac or mysql workbench on windows

 

[Rheadzz]

This is a bit more of a manual solution but I grep -n -A 10 -B 10 'CREATE TABLE' then if the table is between say 50 and 80 I would sed -n '50,80p' then you could grep -E "\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,6}\b" the lines out with email address's or whatever and it should all be a okay format.

 

[Brandon]

You are free to use "Navicat" software. It's easy to export multiple file types on navicat.

OP же написал, что у него есть толкто ФАЙЛ БД размеров в 14Гб, у него нет никаких работающих СУБД вроде MySQL, поэтому все эти дерьмовые инструменты типа Navicat, DBeaver, DbVisualizer бесполезны совершенно!

 

[Brandon]

try sequel pro on mac or mysql workbench on windows

Ну да конечно, для каждой БД свою оболочку прикажите ставить?
Вот у меня есть несколько БД в формате: MongoDB, MSSQL, Elastic и т.д. мне нужно для каждой свою СУБД городить что-бы эскпорт данных в csv сделать?