Cont'd question on database set-up - Blue Sky tutorial
I have a local server set-up on my Mac. I used MAMP. Everything is working correctly.
I'm going through the BlueSky tutorial. I'm on the step where you set up your Database.
First I downloaded the files (PHP DB starter kit) and moved to the appropriate folders:
I moved the site files (DatabaseElearning folder) to the htdocs folder. This contains all the PHP site files.
I moved the "mysqul_dbs" folder which contains the digital_gods.sql and other sql files in it, I moved these to the mysql folder in my local servers db folder
db > mysqul > mysql_dbs > physical_goods.sql
In Dreamweaver I click on Databases to set up the connection. The MySQL Connection box opens up. I name the connection conn_bluesky and enter all the information. Last, I click on Select Database and select "mysql_dbs" from the options listed.
Next I click TEST and the connection is successful.
BUT, when I open the Databases pannel and expand the conn_bluesky it contains no tables.
According to the bluesky tutorial, at the step "Select Database", the physical_goods databse should be one of the options to choose from. However, my choices are "information_schema, mysql, mysql_dbs, and test".
I tried moving files up and down folders and redoing the connection with no success. I've tried restarting my local server and dreamwaver. I'm missing or overlooking something.
Does something need to be done with the .sql files so that they work correctly on the local server?
Can you please advise as to what I'm missing.
Thanks for your help,