Error trying to add a column

[hamish_mcc]

My system is WinXP Home 2002 SP1 & MySQL 3.23.47-nt.

My main database has a couple of dozen tables, and appears to be working fine. I use OpenOffice for most tasks, and the command line to add/edit tables.

Since yesterday, when I try to add a column (either varchar or int), I get this error message:-

mysql> alter table organisations add column IO_gen varchar(255);
ERROR 7: Error on rename of '.\exploitations\organisations.MYI' to '.\exploitations\#sql2-5e0-1.MYI' (Errcode: 13)

I haven't been able to find an explanation of what this means. Can you tell me?

Thanks, Hamish

[hamish_mcc]

Since posting, I have found a page in the MySQL manual which (almost) refers - A.7.1 Problems with ALTER TABLE

Unfortunately, there are no wrongly-named files in \mysql\data to be renamed.

Back to square 1...