[mdlug] MYSQL question

[Brian Brodsky]

I suggest you have another drive that holds your databases. If you are 
using myisam you could point the database directories as symbolic links 
to each individual drive (I would NOT put in web directory). If your are 
using innodb the entire thing is in one workspace.

On 3/18/2011 4:39 PM, mat.enders at gmail.com wrote:
> It is a entirely a question of space. I have separate drives for each site with a fairly small root drive.
> Sent on the Sprint® Now Network from my BlackBerry®
>
> -----Original Message-----
> From: "Wojtak, Greg"<GregWojtak at quickenloans.com>
> Date: Fri, 18 Mar 2011 16:32:10
> To: mat.enders at gmail.com<mat.enders at gmail.com>; MDLUG's Main discussionlist<mdlug at mdlug.org>; Mark Stanislav<mark.stanislav at gmail.com>
> Subject: Re: [mdlug] MYSQL question
>
> May I ask *why* you would want to do this?  It is generally not a good
> practice, as anything under your DocumentRoot technically becomes fair
> game to be served up by the web server.
>
>
>
> On 2011-03-18 4:15 PM, "mat.enders at gmail.com"<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®
>> _______________________________________________
>> mdlug mailing list
>> mdlug at mdlug.org
>> http://mdlug.org/mailman/listinfo/mdlug
> _______________________________________________
> mdlug mailing list
> mdlug at mdlug.org
> http://mdlug.org/mailman/listinfo/mdlug
>