mysql config

[Mark Hughes]

> On Wed, 2002-07-24 at 10:29, Robin Garbutt wrote:
> > does anyone know how to change the path to your db directory in a mysql
> > installation?  Its set to /var/db/mysql by default, but I want to change
> > this.  Any ideas?  I've been into /etc/my.cnf but there aren't any
options
> > there.
>
> It's a compile-time thing.

>   # cd /usr/ports/databases/mysql323-server
>   # make DB_DIR=/where/you/want/it install

Or you can change it in my.cnf in /etc (if you haven't got one simply create
one).... not sure of the directive you need to use (probably
"db_dir=/your/location", not sure), but if you search the online manual (at
www.mysql.com) for it I'm sure you can find the info you require.

Regards,
Mark