.SQL extention question - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

.SQL extention question

Author

Topic

Qabandi
Starting Member

2 Posts

Posted - 2008-09-01 : 14:29:23

WARNING: TOTAL NEWBIE TO SQL and anything related!@

well i was playing around with my SQL server or database (thats how i learn) and i was able to DOWNLOAD a part of my server, it was called DUMP and it gave me a .SQL file but when i open it with notepad i see bunch of code all messed,

how can i open this file with a simple program ?
doesent have to edit just to be able to view this file OFFLINE

--------edit----------

heres an example of whats inside this .SQL file;

at_id`, `parent_id`, `cat_name`, `deleted`, `sub_counter`, `counter`, `cat_colour`, `cat_image`) VALUES ('40', '29', 'Health, Mind & Body', '0', '0', '0', '', '');
INSERT INTO `phpauction_categories`(`cat_id`, `parent_id`, `cat_name`, `deleted`, `sub_counter`, `counter`, `cat_colour`, `cat_image`) VALUES ('41', '29', 'History', '0', '0', '0', '', '');
INSERT INTO `phpauction_categories`(`cat_id`, `parent_id`, `cat_name`, `deleted`, `sub_counter`, `counter`, `cat_colour`, `cat_image`) VALUES ('42', '29', 'Home & Garden', '0', '0', '0', '', '');
INSERT INTO `phpauction_categories`(`cat_id`, `parent_id`, `cat_name`, `deleted`, `sub_counter`, `counter`, `cat_colour`, `cat_image`) VALUES ('43', '29', 'Horror', '0', '0', '0', '', '');
INSERT INTO `phpauction_categories`(`cat_id`, `parent_id`, `cat_name`, `deleted`, `sub_counter`, `counter`, `cat_colour`, `cat_image`) VALUES ('44', '29', 'Literature & Fiction', '0', '0', '0', '', '');
INSERT INTO `phpauction_categories`(`cat_id`, `parent_id`, `cat_name`, `deleted`, `sub_counter`, `counter`, `cat_colour`, `cat_image`) VALUES ('45', '29', 'Animals', '0', '0', '0', '', '');
INSERT INTO `phpauction_categories`(`cat_id`, `parent_id`, `cat_name`, `deleted`, `sub_counter`, `counter`, `cat_colour`, `cat_image`) VALUES ('46', '29', 'Catalogs', '0', '0', '0', '', '');
INSERT INTO `phpauction_categories`(`cat_id`, `parent_id`, `cat_name`, `deleted`, `sub_counter`, `counter`, `cat_colour`, `cat_image`) VALUES ('47', '29', 'Children', '0', '0', '0', '', '');
INSERT INTO `phpauction_categories`(`cat_id`, `parent_id`, `cat_name`, `deleted`, `sub_counter`, `counter`, `cat_colour`

thats abasically a table/schedual or whatever, i need a program to open this piece of code and show me a normal looking table.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-01 : 14:33:11

Your question is not clear. I don't know what you mean by dump as that's a term we used back on SQL Server 6.5. What version of SQL Server are you using? How did the .sql file get created?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Qabandi
Starting Member

2 Posts

Posted - 2008-09-01 : 16:52:23

well, it basically created the .sql in a temporary directory then made me download it, Its a DATABASE of one place in the SQL database.

checkout the first post i edited it with more info

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2008-09-01 : 22:04:30

Are you using Microsoft SQL Server or MySQL ? FYI, this is a MS SQL Server forum

KH
[spoiler]Time is always against us[/spoiler]

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-02 : 00:59:22

What you have described isn't available "out of the box" with SQL Server, so you'll need to give a lot more detail on your download screen if you are using SQL Server. If you aren't using SQL Server, then post your question at dbforums.com in the relevant forum.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources