Well, I found the reason for these table becoming 'read only':
These tables where part of a merge table, which included some read only
tables (read only set in file system).
Now even after the merge table was dropped, all member tables stayed
'read only' regardless of their individual file syste
Very odd problem. I do have a larger database, with many myisam tables.
A couple days ago, some of them turned 'read only'.
Symptom:
delete from day_48392 where id=28398776259;
ERROR 1036 (HY000): Table 'day_48392' is read only
I checked:
- table file permissions are right ('660 mysql:daemon')
t;
To: "Gerald R. Jensen" <[EMAIL PROTECTED]>
Cc: "Kristian Koehntopp" <[EMAIL PROTECTED]>; "MySQL List"
<[EMAIL PROTECTED]>
Sent: Tuesday, July 09, 2002 8:20 PM
Subject: Re: Read-Only MySQL
> Like Kristian says,
>
> I don't see why yo
MAIL PROTECTED]>
> To: "MySQL List" <[EMAIL PROTECTED]>
> Sent: Tuesday, July 09, 2002 6:48 AM
> Subject: Read-Only MySQL
>
> I want to create a CD-ROM which contains a copy of MySQL (for
> Windows) and a set of MySQL datab
AIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, July 09, 2002 6:48 AM
Subject: Read-Only MySQL
I want to create a CD-ROM which contains a copy of MySQL (for
Windows) and a set of MySQL databases. Is it possible to set up
a read-only MySQL, that is, a MySQ
I want to create a CD-ROM which contains a copy of MySQL (for
Windows) and a set of MySQL databases. Is it possible to set up
a read-only MySQL, that is, a MySQL running from a r/o media?
Kristian
-
Before posting, please
Valerie,
Tuesday, April 02, 2002, 9:13:50 PM, you wrote:
VB> I have a mysql table, which gives the error read-only when I use LOAD DATA
VB> INFILE command. How do I change this, I read the online manaul with no
VB> success.
It means that user mysql has no permissions to write in those files.
Hi all,
I have a mysql table, which gives the error read-only when I use LOAD DATA
INFILE command. How do I change this, I read the online manaul with no
success.
Thanks.
-
Valerie Brooks
Fujitsu Software
3055 Orchard Dr.
Sa
