I have downloaded a leak here and it comes in multiple .sql files. I am on MacOS and don't know how to access the data as each file is around 10GB.

The file says it is a -- MySQL dump 10.13 Distrib 5.5.55, for debian-linux-gnu (x86_64)

I don't really know how to use SQL. I downloaded MYSQLWorkbench as per someone's guide on here, but not sure how to use it. Do I need to set up a SQL server and then upload all the data to that server? Or can MYSQLWorkbench open the .sql dump and then display all the columns etc and allow me to sort like I would on Excel?

Basically I want to go from the .sql file into data on Excel, but I am not sure how to do it.

I have tried opening it in Textedit, MYSQLWorkbench, Navicat, but they all just show the commands e.g. CREATE DATABASE, INSERT INTO, etc. That data isn't usable to me in that format.

Let me comment here to give your thread a pump because i have the same issue, when i download a breach in SQL it just won't fucking open in SQL viewing programs such as mysqlworkbench, I want to know how people go on with extracting the data they need such as names, emails..etc

https://www.emeditor.com/

bu işinizi görür basit bir uygulama

If I were you, I'll create a database in phpmyadmin and import the .sql file there. That's what I would do on Windows. I don't know anything about MYSQLWorkbench.