Hi guys I'm looking for the best way to extract data from sql file .

Python code is how I do it.

I custom code for parsing files like SQL.

I know that there are tools like DB Database Explorer for Sqllite. Otherwise just install mysql on your box and run the sql script to read the data.

EDIT: just saw someone already posted a tutorial : https://breached.to/Thread-GUIDE-How-Open-and-view-Sql-and-JSON-Data-Multi-Language

If it is a small file, you can open it through editors. if it is a big file it is better to upload it to mysql server and process it with a backend language.

Simplest one I found that works is here.

https://www.emeditor.com/

Use emeditor.

i use sqlite database browser portable

Id just run an sql database locally.

there's a "mysqltosqlite" converter that's great when it works, but also converting the INSERT INTO statements is a much more painful way to do it.

# cat mydatabase.sql | head +n 109 | sed 's/(/
/g'

etc.

As I said: painful