Can't set tmpdir in mysql

[Ryan Schmidt]

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?