Dear Jocelyn, > > On Win2K with MySQL 4.0.4 I get this error with a MyISAM table: > > mysql> ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL > > PRIMARY KEY; > > ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to > > '.\trainee\#sql2-648-2.MYI' (Errcode: 13)
> Perror 13 means : > perror 13 > Error code 13: Permission denied > So it seems you don't have the permission to create the temporary table is > this directory. First thing I was thinking of. Unfortunately, this is not the problem. If there would actually _be_ a permissions problem, the server would have it, meaning it would not be able to write to this directory. But I can CREATE tables there, so why not temporary ones? Thanks anyway for trying to help! Regards, -- Stefan Hinz <[EMAIL PROTECTED]> Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 ----- Original Message ----- From: "Jocelyn Fournier" <[EMAIL PROTECTED]> To: "Stefan Hinz" <[EMAIL PROTECTED]>; "MySQL Main List" <[EMAIL PROTECTED]> Sent: Monday, November 18, 2002 8:32 PM Subject: Re: Please help with strange Win2K error > Hi, > > Perror 13 means : > > perror 13 > Error code 13: Permission denied > > So it seems you don't have the permission to create the temporary table is > this directory. > > Regards, > Jocelyn > ----- Original Message ----- > From: "Stefan Hinz" <[EMAIL PROTECTED]> > To: "MySQL Main List" <[EMAIL PROTECTED]> > Sent: Monday, November 18, 2002 6:08 PM > Subject: Please help with strange Win2K error > > > > Dear list, > > > > sorry for bothering you again, but no one has answered to my request for > > help so far, not even Jeremy Z. who *I know* can solve every and any > > problem remotely ;-) > > > > On Win2K with MySQL 4.0.4 I get this error with a MyISAM table: > > > > mysql> ALTER TABLE auftrag CHANGE Nummer Nummer INT UNSIGNED NOT NULL > > PRIMARY KEY; > > ERROR 7: Error on rename of '.\trainee\auftrag.MYI' to > > '.\trainee\#sql2-648-2.MYI' (Errcode: 13) > > > > Trying a workaround, I switched the table type of this table to innoDB. > > Now, I can issue the above statement without getting an error. > > > > However, innoDB tables have a MyISAM style .frm file. I get a quite > > similar error when I try the following: > > > > mysql> ALTER TABLE auftrag ADD FOREIGN KEY (Auftraggeber) REFERENCES > > auftraggeber(Schl); > > ERROR 1005: Can't create '.\trainee\#sql-6fc_2.frm'. (Error: 150) > > > > Seems to be an (internal) temporary table problem. Does anyone know > > what's happening, and how to solve this prob? > > > > Any help is greatly appreciated. > > > > Regards, > > -- > > Stefan Hinz <[EMAIL PROTECTED]> > > Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> > > Heesestr. 6, 12169 Berlin (Germany) > > Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 > > > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php