<div dir="ltr"><div><div>I haven't been able to change the tmpdir for mysql. I've set it to /opt/local/tmp in my.cnf but mysql still uses /var/tmp which never worked for some reason. I see no errors in the mysql log file.<br>
<br></div>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 the /opt/local/etc/my.cnf file (with some commented out parts removed)<br><div><div><br>[client]<br>#password = your_password<br>port = 3306<br>socket = /opt/local/var/run/mysql5/mysqld.sock<br><br>
# Here follows entries for some specific programs<br><br># The MySQL server<br>[mysqld]<br>port = 3306<br>socket = /opt/local/var/run/mysql5/mysqld.sock<br>pid-file=/var/run/mysqld/mysqld.pid<br>tmpdir = /opt/local/tmp<br>
skip-locking<br>key_buffer_size = 16M<br>max_allowed_packet = 1M<br>table_open_cache = 64<br>sort_buffer_size = 512K<br>net_buffer_length = 8K<br>read_buffer_size = 256K<br>read_rnd_buffer_size = 512K<br>myisam_sort_buffer_size = 8M<br>
# Don't listen on a TCP/IP port at all. This can be a security enhancement,<br># if all processes that need to connect to mysqld run on the same host.<br># All interaction with mysqld must be made via Unix sockets or named pipes.<br>
# Note that using this option without enabling named pipes on Windows<br># (via the "enable-named-pipe" option) will render mysqld useless!<br># <br>#skip-networking<br><br># Replication Master Server (default)<br>
# binary logging is required for replication<br>log-bin=mysql-bin<br><br># binary logging format - mixed recommended<br>binlog_format=mixed<br><br># required unique id between 1 and 2^32 - 1<br># defaults to 1 if master-host is not set<br>
# but will not function as a master if omitted<br>server-id = 1<br><br><br>[mysqldump]<br>quick<br>max_allowed_packet = 16M<br><br>[mysql]<br>no-auto-rehash<br># Remove the next comment character if you are not familiar with SQL<br>
#safe-updates<br><br>[myisamchk]<br>key_buffer_size = 20M<br>sort_buffer_size = 20M<br>read_buffer = 2M<br>write_buffer = 2M<br><br>[mysqlhotcopy]<br>interactive-timeout<br><br></div></div></div>