MySQL tmpdir setting being ignored ?
Posted on 2014-08-21
Hi. I've got 2 HDD partitions: C: is really small and only has about 3gb of space left. E: has plenty of space and is where my MySQL instance is installed and where the tables are being kept.
I'm running some queries which are failing and I think it's because i'm running out of room on C: while the query uses the temp path C:\Windows\Temp, which as i understand is being read from an environment variable but should be overridden if the tmpdir option is set in the config file. As the query runs i see a growing #sql* file in there.
Anyway. I'd like to re-direct the temp directory to a folder on E:.
To attempt this I:
1) Stopped Mysql (Net Stop Mysql)
2) Modified the settings file via mysql workbench. I changed the tmpdir value and used the browse button to navigate to the desired path so there isn't a chance that i've misspelled it
3) Restarted MySQL (Net Start Mysql)
Now, running a query again, and my tmpdir setting is being ignored. How can I fix this?