changing mysql datadir

[Barry Byrne]

> -----Original Message-----
> From: owner-freebsd-questions at freebsd.org 
> [mailto:owner-freebsd-questions at freebsd.org] On Behalf Of 

> Wonder if you know whether it is possible to change mysql server data 
> dir from the default /var/db/mysql. I looked through my-small.cnf but 
> found no option called datadir.
> 
> If anyone knows how to change or where to look for 
> compile-time options 
> to set a custom datadir, I'd very much appreciate a link. I 
> was able to 

Put the following in /etc/rc.conf

mysql_dbdir="/path/to/datadir"

 - barry