Take the 2-minute tour ×

I'm trying to add keys to an InnoDB table. I started with the small ones(~6.8GB) and I encountered a problem. After a while of processing it throws an 1114 error(table is full). I restarted the process of adding indexes and monitor everything. The problem seems to be that it is using OS's temp dir(running Windows). I have it installed on another drive that has plenty of space. The error is thrown when the space on C:/ approaches 0. Is there anything I could do to have it save its temp files on the same drive where MySQL is installed and not on C:/ ? Thank you

share|improve this question

migrated from stackoverflow.com Feb 3 '12 at 22:44

This question came from our site for professional and enthusiast programmers.

1 Answer 1

Searched a bit more and I found the solution:


tmpdir=[other drive]:/tmp

Now it's writing to the tmp directory on the wanted drive.

share|improve this answer
you might want to specify that it's in the my.cnf config file... –  Stefano Feb 4 '13 at 21:46

Your Answer


