phpfanphp Posted August 23, 2007 Share Posted August 23, 2007 Hello - I am VERY new to PHP In the MySQL command prompt, I type in show databases; Where is this looking on my hard drive? How can I tell? I have a sample .sql database downloaded. Where should this file go? Thanks Quote Link to comment https://forums.phpfreaks.com/topic/66283-simple-show-databases-question/ Share on other sites More sharing options...
Tandem Posted August 23, 2007 Share Posted August 23, 2007 The .sql file isn't the actual database, it's a list of instructions for the MySQL program, written in SQL. To have MySQL execute the instructions, which i am going to guees will create a database, you can use the source command. I believe it works by typing: source (path to .sql file here) You might want to google it for extra options though. Quote Link to comment https://forums.phpfreaks.com/topic/66283-simple-show-databases-question/#findComment-331544 Share on other sites More sharing options...
phpfanphp Posted August 23, 2007 Author Share Posted August 23, 2007 I'll give that a try right now - thanks! Quote Link to comment https://forums.phpfreaks.com/topic/66283-simple-show-databases-question/#findComment-331557 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.