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)
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:
> > :
> > 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: