Re: Error of the day: ER_CANT_CREATE_FILE

[Davi Arnaut]

On 6/23/09 4:11 AM, Stewart Smith wrote:
> On Sat, Jun 13, 2009 at 10:09:13AM -0500, Paul DuBois wrote:
>>
> http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html#error_er_cant_create_file
>> :
>>
>> Error: 1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE)
>>
>> Message: Can't create file '%s' (errno: %d)
>>
>>
>> Likely cause:
>> * Server trying to create file in which it has no write permission?
>
> The never-ever-tested-but-can-still-happen ENOENT and ENOSPC.
>

As i said in a earlier mail, server raises a different error 
(ER_BAD_DB_ERROR) if errno is ENOENT. ENOSPC? sure.. specially if there 
is file system quota or disk is full.