Re: sql error : 1036

2003-07-09 Thread Victoria Reznichenko
"HA. Mooduto" <[EMAIL PROTECTED]> wrote: > dear all, > what is the problem sql error : 1036 ...table is read only. > please help me.. This table is compressed with myisampack or MySQL server doesn't have permissions on the table files. -- For technical

Re: sql error : 1036

2003-07-08 Thread gerald_clark
Does the mysql user have write permissions on the files? HA. Mooduto wrote: dear all, what is the problem sql error : 1036 ...table is read only. please help me.. thank's... -- This mail sent through PSP: http://www.polinpdg.

sql error : 1036

2003-07-08 Thread HA. Mooduto
dear all, what is the problem sql error : 1036 ...table is read only. please help me.. thank's... -- This mail sent through PSP: http://www.polinpdg.ac.id/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Re: Newbie asks error 1036 table read only?

2002-05-16 Thread Egor Egorov
Bill, Wednesday, May 15, 2002, 11:42:00 PM, you wrote: BF> Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM BF> tables on which I am unable to do updates or inserts. I get error BF> message #1036 'Table is read only.' I am able to sign on to the database BF> through the root,

Re: Newbie asks error 1036 table read only?

2002-05-16 Thread Gerald Clark
Make sure mysql owns the tables and their directorys, and has write privileges to them. I talking about UNIX permissions here, not mysql permissions. Bill Flanagan wrote: >Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM >tables on which I am unable to do updates or insert

Newbie asks error 1036 table read only?

2002-05-15 Thread Bill Flanagan
Hi, I recently inherited a Mysql 3.23.46 database, have some old ISAM tables on which I am unable to do updates or inserts. I get error message #1036 'Table is read only.' I am able to sign on to the database through the root, set myself up as a superuser in the user table, and have been able to s

Re: ERROR 1036: Table 'xxx' is read-only

2002-05-03 Thread Victoria Reznichenko
Milan, Friday, May 03, 2002, 2:15:49 PM, you wrote: MR> I have a problem with updating MySQL database on linux with mysql MR> 3.23.24-beta-log. I have prepared a database on Win98 SE platform MR> with 3.23.49a and when i moved to my linux server at school (RedHat MR> 7.0 CZ with MySQL 3.23.24-

Re: ERROR 1036: Table 'xxx' is read-only

2002-05-03 Thread Gerald Clark
They must be owned by the user under which the mysqld runs, or change them to mode 766. Milan Reznicek wrote: >I have a problem with updating MySQL database on linux with mysql >3.23.24-beta-log. I have prepared a database on Win98 SE platform >with 3.23.49a and when i moved to my linux server

Re: ERROR 1036: Table 'xxx' is read-only

2002-05-03 Thread sucker
- Original Message - From: "Milan Reznicek" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, May 03, 2002 1:15 PM Subject: ERROR 1036: Table 'xxx' is read-only > I have a problem with updating MySQL database on linux with mysql > 3.23.2

ERROR 1036: Table 'xxx' is read-only

2002-05-03 Thread Milan Reznicek
I have a problem with updating MySQL database on linux with mysql 3.23.24-beta-log. I have prepared a database on Win98 SE platform with 3.23.49a and when i moved to my linux server at school (RedHat 7.0 CZ with MySQL 3.23.24-beta-log) I can't update or insert to table. I have changed rights t

Re: MySQL Error: 1036 (Table 'tblHSBOYArticle_basic' is read only)

2001-08-16 Thread Irmund Thum
> MySQL Error: 1036 (Table 'tblHSBOYArticle_basic' is read only) > Session halted. go to the mysql monitor and: use database; describe blHSBOYArticle_basic; - Before posting, please check: http://www.mysq

MySQL Error: 1036 (Table 'tblHSBOYArticle_basic' is read only)

2001-08-16 Thread ÇóÊdz±
s are read only. PHP said: MySQL Error: 1036 (Table 'tblHSBOYArticle_basic' is read only) Session halted. I don't know what's wrong with it. I "chmod 777", but it does not work yet, then I grant insert,update,delete to the table, it doesn't get better.

Re: win2k ERROR 1036 (read only) problem

2001-07-23 Thread Sinisa Milivojevic
Panos Melas writes: > Hello everyone, > > I try to install and configure mysql under win2000, initally it seems to > work ok but whenever I try to create a table or modify any of the existing > tables I get the following error: ERROR 1036: Table is read only > > e.

RE: win2k ERROR 1036 (read only) problem

2001-07-23 Thread Bruce Stewart
Using the 'GRANT' syntax is the recommended method for assigning permissions. -Original Message- From: Panos Melas [mailto:[EMAIL PROTECTED]] Sent: Mon, 23 July 2001 13:51 To: '[EMAIL PROTECTED]' Subject: win2k ERROR 1036 (read only) problem Hello everyone,

win2k ERROR 1036 (read only) problem

2001-07-23 Thread Panos Melas
Hello everyone, I try to install and configure mysql under win2000, initally it seems to work ok but whenever I try to create a table or modify any of the existing tables I get the following error: ERROR 1036: Table is read only e.g. mysql> insert into user values('localhost

Re: Error 1036

2001-02-28 Thread Rolf Hopkins
ROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, March 01, 2001 3:24 Subject: Re: Error 1036 > At 12:25 28/02/2001 +0100, Produktberatung wrote: > Hi! > The MySQL table has a primary key ?. > If the answer is no, add a primary key and try again. > > Regards, > Miguel &

Re: Error 1036

2001-02-28 Thread Miguel Angel Solórzano
reat Tool! From any place I can use >all the tables only one table is read-only and I can't edit or delete any of >the rows. It gives both on mysql.exe and on Acc97 ODBC Error 1036 Table is >read only. In Explorer I checked it twice but it's not read only. But I have >to edit i

Error 1036

2001-02-28 Thread Produktberatung
Hi You, I have some trouble with my MYsql installation. I imported several tables from Foxpro that run/perform EXCELLENT! Great Tool! From any place I can use all the tables only one table is read-only and I can't edit or delete any of the rows. It gives both on mysql.exe and on Acc97 ODBC