How to use .sql files
by crushingapples - August 15, 2019 at 03:48 PM
#1
Hi Folks,

Today I have downloaded a couple of dbs where it is having files .sql in it. I am not sure how to use those files. Can anyone please advise me on the same?
Reply
#2
Software that opens .sql files
Reply
#3
Or just open it on a website that you can open file on
Reply
#4
i use sqlite - works for most
Reply
#5
Hosting your own sql server locally could also be an option. You should learn basics like SELECT and JOIN.
Reply
#6
I run sql on my Linux. I import the dump.
mysql -u username –-password=your_password database_name < file.sql

That way I can run sql commands on the database.
Like
Select * from customers;
Reply
#7
Just download any sql opener
Reply
#8
sqlworkbench can help import 4 u
Reply
#9
what do you mean by use ?
Do you mean like actually use it actively on a hosted site or do you mean use it as in open and read the file ?
Both are easy btw
Reply
#10
You got all sorts of options man, just pick an app to open and read them.
Reply
#11
As others have said, you can use these files and import the content into a database. Think of them as kinda of like scripts. They automate the creation and population of databases. Most of the sql found here is going to be compatiable with MySQL (MariaDB). You can also regex/grep them as the formating of the data is standardized (usually), and just pull out the bulk data you want.

I do not know of any tools (perhaps I will create one if people are interested enough), but it should be possible with the right scripts/tools to convert these files into XML or JSON too. For sure you can export the data to CSV/XML/etc once imported into a database system.

Good question. Hope my answer helped a bit. Feel free to ask me any follow up questions or whatever.
Reply
#12
sqlite is very simple tool to manage sql files
Reply

Possibly Related Threads…
Thread Author Replies Views Last Post
Do you use password manager? olgatami33 31 457 2 hours ago
Last Post: blackhacker19
What do you use for online people search? maxraid 7 131 August 14, 2019 at 10:37 PM
Last Post: xameleon
How to use Sage Password Recovery Tool? sagesupportnumber 0 53 August 13, 2019 at 08:12 AM
Last Post: sagesupportnumber

 Users browsing this thread: 1 Guest(s)