Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI' (Errcode: 13)

Hi everybody! Peng Yu wrote: > Hi, > > I run the following command. But I got the following error. I'm not > sure what causes the problem. I have seen the same issue before, but > it disappeared even I didn't take any action. Could anybody let me > know how to fix the problem? > > mysql -ugenom

Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI' (Errcode: 13)

On Tue, Jan 18, 2011 at 6:24 AM, sushant chawla wrote: > Make sure the following things: > > > - /tmp folder is having 1777 permissions > - mysql folder is having the ownership from which it is running. Refer > /etc/my.cnf > - Make sure you have space on your MySQL partition > Also, make

Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI' (Errcode: 13)

Make sure the following things: - /tmp folder is having 1777 permissions - mysql folder is having the ownership from which it is running. Refer /etc/my.cnf - Make sure you have space on your MySQL partition Regards Sushant Chawla On Tue, Jan 18, 2011 at 10:51 AM, Yogesh Kore wro

Re: ERROR 1 (HY000): Can't create/write to file '/var/lib/mysql/#sql_9e1_0.MYI' (Errcode: 13)

May be db files are not as MySQL user. Check owner ship for the files of the table. It should be mysql user ownership. On Tue, Jan 18, 2011 at 6:36 AM, Peng Yu wrote: > Hi, > > I run the following command. But I got the following error. I'm not > sure what causes the problem. I have seen the sam

RE: Error -1

>-Original Message- >From: Martin Gainty [mailto:mgai...@hotmail.com] >Sent: Monday, March 23, 2009 11:49 AM >To: Jerry Schwartz; wagnerbian...@yahoo.com.br >Cc: mysql@lists.mysql.com >Subject: RE: Error -1 > > > >SELECT bunch_of_columns FROM bun

RE: Error -1

>-Original Message- >From: Jerry Schwartz [mailto:jschwa...@the-infoshop.com] >Sent: Saturday, March 21, 2009 9:57 PM >To: 'MySql' >Subject: Error -1 > >I'm running 5.1.31-community on WinXP. > >I’m getting > >ERROR 1030 (HY000): Got error -1 from storage engine > >from the following quer

RE: Error -1

liability for the content provided. > From: jschwa...@the-infoshop.com > To: wagnerbian...@yahoo.com.br > CC: mysql@lists.mysql.com > Subject: RE: Error -1 > Date: Mon, 23 Mar 2009 10:26:36 -0400 > > > > From: Wagner Bianchi [mailto:wagnerbian...@yahoo.com.br] &

RE: Error -1

From: Wagner Bianchi [mailto:wagnerbian...@yahoo.com.br] Sent: Monday, March 23, 2009 7:57 AM To: Jerry Schwartz Subject: Res: Error -1 Hi friend, You can use this, but, the -1 Error you got on the situation in you use InnoDB and it's crash. [JS] I'm not using InnoDB for this table, it needs

Re: ERROR 1: Can't create/write to file (Errcode: 13)

Thanks, it was just about the set the right for the mysql user, as - you already correctly mentioned - mysql runs as user mysql. Thanks and regards, Stephan Gloor > Stephan Gloor wrote: > >>On Fri, 4 Oct 2002, Stephan Gloor wrote: > >> > >> > >>>When trying to create an index on > >>> > >>

Re: ERROR 1: Can't create/write to file (Errcode:13)

Stephan Gloor wrote: >>On Fri, 4 Oct 2002, Stephan Gloor wrote: >> >> >>>When trying to create an index on >>> >>>Table ANSCHLUSS: >>>| ID | int(11) | | PRI | NULL| auto_increment | >>>| TELEFON | varchar(20) | | MUL | || >>>| REGION |

Re: ERROR 1: Can't create/write to file (Errcode: 13)

> On Fri, 4 Oct 2002, Stephan Gloor wrote: > > > When trying to create an index on > > > > Table ANSCHLUSS: > > | ID | int(11) | | PRI | NULL| auto_increment | > > | TELEFON | varchar(20) | | MUL | || > > | REGION | int(11) |

Re: ERROR 1: Can't create/write to file (Errcode:13)

On Fri, 4 Oct 2002, Stephan Gloor wrote: > When trying to create an index on > > Table ANSCHLUSS: > | ID | int(11) | | PRI | NULL| auto_increment | > | TELEFON | varchar(20) | | MUL | || > | REGION | int(11) | | | 0