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
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
migrated from stackoverflow.com Feb 3 '12 at 22:44
This question came from our site for professional and enthusiast programmers.