Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 08 Mar 2021 16:03:49 +0000
From:      bugzilla-noreply@freebsd.org
To:        ports-bugs@FreeBSD.org
Subject:   [Bug 194305] databases/mariadb,mysql,percona*-server: Does not respect/honour user-specified datadir directive in my.cnf
Message-ID:  <bug-194305-7788-lWxMXkxaSA@https.bugs.freebsd.org/bugzilla/>
In-Reply-To: <bug-194305-7788@https.bugs.freebsd.org/bugzilla/>
References:  <bug-194305-7788@https.bugs.freebsd.org/bugzilla/>

next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D194305

SolarCatcher <solarcatcher@gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |solarcatcher@gmx.de

--- Comment #39 from SolarCatcher <solarcatcher@gmx.de> ---
Just found this bug report - after spending several hours trying to move the
data-directory to the place suggested by percona for ZFS.

I can happily live with configuring the datadir through the mysql_dbdir
variable in rc.conf. But a warning in /usr/local/etc/mysql/confd./server.cnf
would be very useful.=20

Currently the standard server.cnf file includes under [mysqld]

datadir  =3D /var/db/mysql

And, commented out, suggests setting it for ZFS to
datadir =3D /var/db/mysql/data

None of these configuration directives have any effect, because datadir is
overriden by the rc variable mysql_dbdir when starting mysql-server via the
script in rc.d. It would probably help to clearly state this in server.cnf.

--=20
You are receiving this mail because:
You are the assignee for the bug.=



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-194305-7788-lWxMXkxaSA>