<div dir="ltr"><div><div>I got it working now.<br><br></div>I did mean /opt/local/etc/my.cnf but it turns out the file need to be in /opt/local/etc/mysql5/my.cnf. When I had a my.cnf in there it caused mysql startup to fail saying "Manager of pid-file quit without updating file." I thought it was a problem with the pid file. I finally saw in the log it was "File ‘./mysql-bin.index’ not found (Errcode: 13)" I solved it by removing binary logging from the my.cnf as recommended <a href="http://birdchan.com/home/2011/09/26/osx-mysql-not-working-after-a-reboot/">here</a>.<br>
<br></div>/var/tmp doesn't work unless I change the ownership from root:wheel to root:admin, but that gets undone after reboot, so I created /opt/local/tmp. It is using this directory correctly now, as specified in the my.cnf.<br>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Jan 7, 2014 at 9:48 AM, Ryan Schmidt <span dir="ltr"><<a href="mailto:ryandesign@macports.org" target="_blank">ryandesign@macports.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="im">On Jan 6, 2014, at 22:28, Darwin O'Connor wrote:<br>
<br>
> I haven't been able to change the tmpdir for mysql.<br>
<br>
</div>I doubt this is a MacPorts-specific issue so you may have more luck writing to a MySQL-specific support venue.<br>
<div class="im"><br>
> I've set it to /opt/local/tmp in my.cnf<br>
<br>
</div>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.<br>
<div class="im"><br>
> but mysql still uses /var/tmp which never worked for some reason. I see no errors in the mysql log file.<br>
<br>
</div>In what way does using /var/tmp as the temporary directory not work?<br>
<div class="im"><br>
> I believe I had it working before, but the my.cnf was wiped during an incident when the disk was full.<br>
><br>
> This is ls -l for the tmp directory<br>
> drwxrwxrwx 2 root admin 68 5 Jan 21:54 tmp<br>
<br>
</div>This is /var/tmp or /opt/local/tmp?<br>
<br>
</blockquote></div><br></div>