List:Internals« Previous MessageNext Message »
From:Rick James Date:June 23 2009 7:29pm
Subject:RE: Error of the day: ER_CANT_CREATE_FILE
View as plain text  
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
> 
> 
Thread
Error of the day: ER_CANT_CREATE_FILEPaul DuBois13 Jun
  • Re: Error of the day: ER_CANT_CREATE_FILEDavi Arnaut13 Jun
    • Re: Error of the day: ER_CANT_CREATE_FILEDavi Arnaut13 Jun
    • Re: Error of the day: ER_CANT_CREATE_FILEMichael Widenius24 Jun
      • Re: Error of the day: ER_CANT_CREATE_FILEDavi Arnaut24 Jun
      • Re: Error of the day: ER_CANT_CREATE_FILEDavi Arnaut24 Jun
  • Re: Error of the day: ER_CANT_CREATE_FILEStewart Smith23 Jun
    • RE: Error of the day: ER_CANT_CREATE_FILERick James23 Jun
    • Re: Error of the day: ER_CANT_CREATE_FILEDavi Arnaut23 Jun