[mdlug] MYSQL question

[Mark Stanislav]

If you do that, you likely need to create a symlink back to your MySQL 'datadir' so it doesn't get upset. Not sure how/if you can arbitrarily place databases on the filesystem and have MySQL know about them in disparate places.

-Mark

On Mar 18, 2011, at 4:15 PM, mat.enders at gmail.com wrote:

> What if you want the database(s) for each web site to live in the document root with all of the other data for that web site?  Is there anything wrong with that?
> ------Original Message------
> From: Mark Stanislav
> To: Mat Enders
> To: MDLUG's Main discussion list
> Subject: Re: [mdlug] MYSQL question
> Sent: Mar 18, 2011 4:04 PM
> 
> Likely /var/lib/mysql/<database name> depending on distro & configuration.
> 
> There's no direct filesystem coupling of web sites and databases as they are separate services within their own hierarchical structure. 
> 
> -Mark
> 
> On Mar 18, 2011, at 4:01 PM, mat.enders at gmail.com wrote:
> 
>> Hello all,
>> 
>>         I have a quick question. If you have multiple web sites on a server where do the database(s) associated with those sites live?  Do they live in the document root for each web site e.g. /var/www/site1, /var/www/site2?
>> 
>> Thanks,
>> Sent on the Sprint® Now Network from my BlackBerry®
>> _______________________________________________
>> mdlug mailing list
>> mdlug at mdlug.org
>> http://mdlug.org/mailman/listinfo/mdlug
> 
> 
> Sent on the Sprint® Now Network from my BlackBerry®