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

[Gregg Levine]

On 10/5/07, Brandorr <brandorr at opensolaris.org> wrote:
> On 10/5/07, Peter C. Norton <spacey-nylug at lenin.net> wrote:
> > 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.
>
> If that is the case how do people support concurrent installs of mysql 4 and 5?
> >
> > -Peter
> >
> >
> > --
> > The 5 year plan:
> > In five years we'll make up another plan.
> > Or just re-use this one.
> >
> > > - Brian Gupta
>
> http://opensolaris.org/os/project/nycosug/
>
Hello!
Besides the fact that Peter is indeed correct, besides I did discuss
most of what he's writing here with a MySQL representative a long
while ago. Now as to your question, its the same way porcupines mate.
Very carefully.
-- 
Gregg C Levine gregg.drwho8 at gmail.com
"This signature was once found posting rude
 messages in English in the Moscow subway."