|
I have a file with an .sql suffix and I want to see the database. How can I get it? I use a Mac. |
|
I use MySQL for SQL databases. This is for online databases. In this scenario, you would use Apache + MySQL, a good choice would be XAMPP (or LAMPP for Linux). Once your server is setup, create a new database and import your .sql file into the query window. And there ya go :P |
|
XAMP, Lamp and Wamp are good for testing or for taking a quick look into testing what you need to do with the three combine. But if you are look for a dedicated server for home lan and all that Then I would suggest Apache or IIS under the windows environment if your using windows as well. Or just Apache and mysql that you can download both as well on your own. |
|
A .sql file is just a text file; your ability to "see" the database will depend on what SQL instructions and queries have been put in it, and how you use it. The .sql file itself is not a database. Now you'll need to connect to a database. Depending on which type of SQL Server you're using, you'll need different programs to connect to it. Microsoft SQL Server, for example, uses SQL Server Management Studio. You'll need to install the appropriate program to connect to whatever kind of server it is. If the database already exists somewhere, the program will have an easy-to-find that says "Connect", "Register Server", or something similar. Connect to the database using the credentials provided by whoever setup or currently administers the database. Then you can import your .sql file and run it. Be careful, though; if you don't know what's in it, it could alter or eliminate your data and structure. If the database does not exist, it will need to be created. Your .sql file may contain the instructions needed to do so. |
