dbTalk Databases Forums  

Newbie: MySql Data Folders

comp.database.ms-access comp.database.ms-access


Discuss Newbie: MySql Data Folders in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
kenny
 
Posts: n/a

Default 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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.