Simple Machines Community Forum

Archived Boards and Threads... => Archived Boards => SMF Feedback and Discussion => Topic started by: Paul123 on October 04, 2009, 03:35:21 AM

Title: How to view/read .sql file (database file) on computer
Post by: Paul123 on October 04, 2009, 03:35:21 AM
Hi,

I downloaded the .sql file (back up file).  Is there any software that I can run/view this file on my PC?  I'd like to view this file on my PC as same as what it is shown on the server, just like I have another indentical forum but running on my PC without connecting to server.

Thanks,
Title: Re: How to view/read .sql file (database file) on computer
Post by: tyty1234 on October 04, 2009, 03:38:19 AM
I think you are able to view it with Firefox.
Title: Re: How to view/read .sql file (database file) on computer
Post by: Arantor on October 04, 2009, 04:30:38 AM
You can view it in Notepad if you like, but it's just a text file containing a series of instructions.

To actually be able to use it, you require a database server (typically MySQL) and then to import that into it, either by command line or a tool such as phpMyAdmin.

Your best bet would be to run a local webserver with the above packages, if you're on Windows, Xampp would likely be your best choice.
Title: Re: How to view/read .sql file (database file) on computer
Post by: Paul123 on October 05, 2009, 02:33:25 PM
Quote from: Arantor on October 04, 2009, 04:30:38 AM
You can view it in Notepad if you like, but it's just a text file containing a series of instructions.

To actually be able to use it, you require a database server (typically MySQL) and then to import that into it, either by command line or a tool such as phpMyAdmin.

Your best bet would be to run a local webserver with the above packages, if you're on Windows, Xampp would likely be your best choice.

Thanks a lot.  This is very useful.  I'll try to install them on my PC.  Thanks again
Title: Re: How to view/read .sql file (database file) on computer
Post by: Thantos on October 05, 2009, 02:51:35 PM
Please do not that the install and upgrade SQL files are not pure SQL.  They do contain some coded instructions in them.