[nylug-talk] Is there a general best practice location to install mysql?

[Peter C. Norton]

On Thu, Oct 04, 2007 at 06:19:20PM -0400, Brandorr wrote:
> I am compiling it and want to match any typical filesystem locations
> for installation.
> 
> Do I install in / ? Or in /usr  or in /usr/mysql5 or in /usr/mysql/5.0 ??

Unless your distro has specific requirements (eg using arch or another
symlink system), the norm is to install the binaries in /usr/bin,
libraries in /usr/lib (or /usr/lib64 if you're going for a dual-abi),
and have data in /var/mysql. Configuration should go either into /etc
for a single file, /etc/mysql/ for configuration only, or sometimes
/var/lib/mysql/ with symlinks /etc/mysql. I'm not clear why the last
is done commonly, but I suspect it's so that everything important and
relevant to the database is on the same filesystem and can be moved
around as needed.

-Peter 


-- 
The 5 year plan:
In five years we'll make up another plan.
Or just re-use this one.