I had this error under win when using phpMyAdmin quite frequently.
It turned out that mysql creates temp files and somehow the
process terminates.
To get along, I dump the table, edit the sql file and reimport.
Never had a problem with this method.
Charles Mégnin schrieb am Freitag, 17. August 2001, 11:00:08:
> I am trying to change the name of a table column and get the following
> error message. I've tried both as a user and as root with no success.
> Thanks for your ideas
mysql>> use music
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
> Database changed
mysql>> alter table label
> -> change name label_name varchar(30);
> ERROR 1: Can't create/write to file './music/#sql-28a_2d.frm' (Errcode:
> 13)
> ---------------------------------------------------------------------
> 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
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 ˇ Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
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