Can't set tmpdir in mysql
ryandesign at macports.org
Tue Jan 7 06:48:01 PST 2014
On Jan 6, 2014, at 22:28, Darwin O'Connor wrote:
> I haven't been able to change the tmpdir for mysql.
I doubt this is a MacPorts-specific issue so you may have more luck writing to a MySQL-specific support venue.
> I've set it to /opt/local/tmp in my.cnf
You mean /opt/local/etc/my.cnf? Are the other values in this file taking effect? Changing them does actually change things? I ask because MySQL checks various locations for my.cnf files, and I don’t remember what the order is or what happens if they’re found in multiple locations; possibly one of them takes precedence.
> but mysql still uses /var/tmp which never worked for some reason. I see no errors in the mysql log file.
In what way does using /var/tmp as the temporary directory not work?
> I believe I had it working before, but the my.cnf was wiped during an incident when the disk was full.
> This is ls -l for the tmp directory
> drwxrwxrwx 2 root admin 68 5 Jan 21:54 tmp
This is /var/tmp or /opt/local/tmp?
More information about the macports-users