Newbie: MySql Data Folders -
06-18-2006
, 06:42 AM
Will appreciate any advice - trying to learn MySql on WinXP laptop
with EasyPhp installed.
My Problem: Struggling to follow the Files-Databases-Tables-Paths
relationships after the simplicity of Access 'one file' database
methods, eg one folder outside webroot called /databases which
contains all the .mdb's in use.
My Question/s:
(1) If I create a MySql database called Fred, MySql seems to create a
folder for it, eg /MySql/Data/Fred/
Does this imply that
(a) each MySql database requires/prefers its own folder for the
'multiple files' that get generated, and
(b) must these always be off the /MySql/data/ folder.
(2) My existing asp setup looks for the Access databases outside the
site roots, folders like
c:/inetpub/wwwroot/Proj1/databases
c:/inetpub/wwwroot/Proj1/site1/
c:/inetpub/wwwroot/Proj1/site2/
(a) Can I put all the MySql 'database' files in
c:/inetpub/wwwroot/Proj1/databases and attempt to map MySql/Php/Apache
to it, or
(b) should it look more like
c:/inetpub/wwwroot/Proj1/databases/MySqlDB1
c:/inetpub/wwwroot/Proj1/databases/MySqlDB2
and how do I map to that
Thank you for anyone with the patience to enlighten me, sorry if its a
stupid question
Kenny
Brain-dead from getting 'Easy'PHP running with IIS. |