Friday, October 26, 2007

Unable to use 'Desc < table name >' ERROR 1 (HY000): Can't create/write to file 'C:\WINDOWS\TEMP\#sql_16cc_0.MYD' (Errcode: 17)

This issue happens (mostly) if you have McAfee :(

http://bugs.mysql.com/bug.php?id=9551
(last paragraph...)

Simple method (not-recommended):
- Disable On Access Scan

A good solution
-
..to move MySQL's temp folder (by adding/changing the "tempdir" directive in my.ini) to an arbitrary directory OTHER THAN C:\WINDOWS\TEMP, and then exclude that directory from within McAfee's On-Access Scanner options.
..................................................

Steps Taken:
1. What is errcode: 17 ?

use the perror command.

c:\>perror 17
OS error code 17: File exists

it means.. the file exists in the temp dir..

2. deleted the file..
#sql_16cc_0.MYD

3. Resolved.

Information regarding this error on MySQL's site

No comments: