In Unix, ENOENT:
* Inadequate permissions on the directory where the file is to live.
* (perhaps?) The file exists, but is not writable.
Note: the 'user' in question is probably 'mysql'. An improper install
may have left all directories and files owned by 'root'. Remedy:
chown -R mysql .../mysql/
(using the appropriate path, and being root while running the command)
Rick James
MySQL Geeks - Consulting & Review
> -----Original Message-----
> From: Stewart.Smith@stripped [mailto:Stewart.Smith@stripped] On
> Behalf Of Stewart Smith
> Sent: Tuesday, June 23, 2009 12:12 AM
> To: Paul DuBois
> Cc: Internals List
> Subject: Re: Error of the day: ER_CANT_CREATE_FILE
>
> 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.h
tml#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.
>
> EFBIG could also happen i guess.
>
> --
> Stewart Smith
>
> --
> MySQL Internals Mailing List
> For list archives: http://lists.mysql.com/internals
> To unsubscribe:
> http://lists.mysql.com/internals?unsub=1
>
>
