Table says it is read only but it is not from file system level

2002-10-01 Thread Rochester, Dean
I am running an sql insert against a mysql table version 3.23.52 When from the file system level the table has the following permissions. rw-rw-r-- table.frm rw-rw-r-- table.MYD rw-rw-r-- table.MYI When the sql runs it says the table is read only. I am connecting to the table as root

Re: Table says it is read only but it is not from file system level

2002-10-01 Thread Iikka Meriläinen
On Tue, 1 Oct 2002, Rochester, Dean wrote: I am running an sql insert against a mysql table version 3.23.52 When from the file system level the table has the following permissions. rw-rw-r-- table.frm rw-rw-r-- table.MYD rw-rw-r-- table.MYI Hi, Please verify that the user mysqld

Re: Table says it is read only but it is not from file system level

2002-10-01 Thread gerald_clark
You are connecting th the server, not the table. The server must have read and write permissions on the files. They must be owned by mysql, as must their directories. Rochester, Dean wrote: I am running an sql insert against a mysql table version 3.23.52 When from the file system level the

Re: Table says it is read only but it is not from file system level

2002-10-01 Thread Mark
- Original Message - From: Rochester, Dean [EMAIL PROTECTED] To: MySQL (E-mail) (E-mail) [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 8:22 PM Subject: Table says it is read only but it is not from file system level I am running an sql insert against a mysql table version 3.23.52