Unable to modify a table

Question

I'm having trouble with mysql. I can read and write, but now I want to add some fields to a table. I run this command: ALTER TABLE Pubs ADD COLUMN issue tinyint AFTER volume;

but get this error message: ERROR 7 (HY000): Error on rename of './user_acct/Pubs.MYI' to './user_acct/#sql2-cb0-76f2.MYI' (Errcode: 13)

I created this table a few months ago, modified it a little bit, so it worked then. I can still update and insert items, but I just can't modify the table anymore.

Any help would be appreciated.

--Dave

Answer 1

You can use perror to undesrtand mysql error:

$ perror 13
OS error code  13:  Permission denied

Answer 2

Do the MySQL user on the system have write permission to the ./user_acct/ folder?