close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Taking static site content to dynamic

Thread began 12/27/2010 6:27 pm by danielleturk361661 | Last modified 1/10/2011 3:54 pm by danielleturk361661 | 1205 views | 9 replies

turk361661

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


The Issue:
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,
Danielle

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...