Solved

What content does .sql file consists

Posted on 2015-02-15
2
94 Views
Last Modified: 2015-02-24
Hello,

What does the .sql file consists of exactly. I got .sql file and when I open it in notepad can see table structure for tables and dumping data for that tables.

For table structure for some tables there is no dumping data so what does this mean.
0
Comment
Question by:srinivas2324
2 Comments
 
LVL 3

Expert Comment

by:Leo Alexander
ID: 40611731
The .sql file contains code to create/query a table or tables. There is no dataset/table in the file itself, aside from the instructions/code on what to do with the data.

You would need software in order to execute the script. You could use MySQL  if you do not have a SQL server installed to read the file into.
0
 
LVL 18

Accepted Solution

by:
Simon earned 500 total points
ID: 40611774
>For table structure for some tables there is no dumping data so what does this mean.

When the other person created the file they chose to include structure only for those tables, or deleted the INSERT statements after creating the file.

It sounds like your .sql file is intended to create the database(s), but only provides data for configuration/lookup tables, leaving it ready for you to populate the other tables.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
php mysql if then statement syntax 4 35
First name pregmatch 11 36
how to get total ticket count on days wise using mysql 24 53
Trigger usage 2 59
A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now