Error trying to add a column
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?
And I thought I'd found it
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...