Date: Wed, 10 Aug 2016 19:38:54 +0000 From: bugzilla-noreply@freebsd.org To: freebsd-ports-bugs@FreeBSD.org Subject: [Bug 194305] databases/mariadb55-server (probably mysql too) ignores datadir directive in my.cnf Message-ID: <bug-194305-13-yoELBKQAME@https.bugs.freebsd.org/bugzilla/> In-Reply-To: <bug-194305-13@https.bugs.freebsd.org/bugzilla/> References: <bug-194305-13@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 --- Comment #14 from MMacD <scratch65535@att.net> --- In rx to Markus (also Kubilay and Mahdi): "FreeBSD uses a different standard for the location of the databases (MySQL/MariaDB/Percona-Standard: /var/lib/mysql vs. FreeBSD-Standard: /var/db/mysql" That's not the FreeBSD standard, per hier(7). Non-system databases shouldn= 't be in /var/db: "[/var/]db [holds] miscellaneous automatically generated system-specific database files". The MariaDB docs do say that /var/lib/mysql is the default location, but th= ey make clear that the datadir directive in my.cfg is meant to be set to provi= de the real location: "The data directory location is controlled by the datadir variable. ... The default is /var/lib/mysql but it is often changed, like f= or example if you are using a RAID array." Since hier(7) specifies that only scratch database files generated by and f= or the system are meant to go in /var/db, MariaDB's /var/lib is more appropria= te as a temporary staging area-- hier(7) doesn't allocate that subtree.=20=20 The center of the problem, though, is that datadir in my.cnf is and has been being ignored, making it hard on nitwits like me who didn't/don't know about the non-standard /etc/rc.conf kludge. --=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-13-yoELBKQAME>