"Newbee" question of where to store database tables ???

Report · Mar 05, 2011

I am a “newbee” so if what I say is not clear please excuse me. I am using DW CS5 as part of the Master Collection.

I have defined my site (in my F:\data\website folder) and have developed a number of static html pages that work well. I now need to add dynamic PHP databases info. I have installed WAMP in the default C:\wamp director.

I have done some testing, and all look OK. I can store and recover database info that is stored in the C:\wamp director

My question:

I would like for my new database and its associated tables to be stored in my F:\data\website\ folder with the html pages so that my DW website folder includes all the associated files.

1. Is this a good idea or should I store them on the default WAMP (C:\wamp) folder?

2. How do I set up my DW test server to see the database located in my F:\data\website folder?

Is Is there a video or how to info posted anyplace?

O

I

Report · Mar 05, 2011

Hi and welcome to the forums !

tenoc wrote:
I would like for my new database and its associated tables to be stored in my F:\data\website\ folder with the html pages so that my DW website folder includes all the associated files.

Dreamweaver will not treat a binary database file which has been stored in your local web root as "associated file", because it isn´t one and should not be stored neither here nor in the remote server´s web root.

should I store them on the default WAMP (C:\wamp) folder?

When setting up a database on your local server using a tool such as phpMyAdmin, the associated binary file will be stored in the default predefined location anyway, and your MySQL server (also phpMyAdmin itself) expects it to be stored there, otherwise it´s inaccessible.