On Monday 15 March 2004 01:02, Chuck Gadd wrote:
> Smartyone wrote:
> > The database used to work, but then something must have broke, because
> > now it is suddenly Read-Only (reports Read Only when I try to add a
> > record using MySQLCC).
>
> Make sure the owner and group of the database files i
Smartyone wrote:
The database used to work, but then something must have broke, because now it
is suddenly Read-Only (reports Read Only when I try to add a record using
MySQLCC).
Make sure the owner and group of the database files is set
to mysql.
--
MySQL General Mailing List
For list archiv
Bennett Haselton wrote:
At 11:22 AM 8/17/2003 -0400, Rajesh Kumar wrote:
Bennett Haselton wrote:
I had already run the command:
grant all on tracerlock.test to bhaselto identified by ""
and that didn't work when I did it, but I didn't restart mysql after
running the command. Probably it was the
Thanks. Actually, my ISP helped me out and got this fixed. Here's what
they wrote in the support log:
>>>
Due to the method that the databases were copied over, I went into mysql
used the grant option on all the databases to allow root access and ability
to alter all the databases. Once this w
Hi Bennett
I had a similar problem on my system a while back. With my particular
case, the problem was the the default priv's on the new server for it's
users did NOT include INSERT rights.
Basically what I'm saying is: these are the reasons for a table to be
(or appear to be) read-only:
1) Table
I searched on Google and I found this post from 2 years ago:
http://www.phpbuilder.com/mail/php-db/2001082/0212.php
suggesting that the way to do it would be to connect to MySQL as root and
run the command:
grant all on tracerlock.test to bhaselto identified by ""
I tried that, and then did "flus
At 05:54 PM 8/16/2003 -0400, Rajesh Kumar wrote:
Bennett Haselton wrote:
I'm trying to port my MySQL tables for a database called "tracerlock"
from one server to another. On the old server, in the
/var/lib/mysql/tracerlock directory, there was a ".MYD", ".MYI" and
".frm" file for every table in
Bennett Haselton wrote:
I'm trying to port my MySQL tables for a database called "tracerlock"
from one server to another. On the old server, in the
/var/lib/mysql/tracerlock directory, there was a ".MYD", ".MYI" and
".frm" file for every table in the database. So after creating a
database cal
On Saturday 29 March 2003 10:32, Joseph Bannon wrote:
> I'm trying to update a table and I get this error
> message.
>
> ERROR 1036: Table 'list' is read only
Is your table compressed with myisampack?
Check also permissions on the table files.
--
For technical support contracts, goto https://o
porate Networking Services
> > Tel: +27 21 854 7064
> > Cell: +27 72 434 7582
> >
> > - Original Message -
> > From: "Francisco Reinaldo" <[EMAIL PROTECTED]>
> > To: "Tonu Samuel"
> > <[EMAIL PROTECTED]>
> > Cc: "
rporate Networking Services
> Tel: +27 21 854 7064
> Cell: +27 72 434 7582
>
> - Original Message -
> From: "Francisco Reinaldo" <[EMAIL PROTECTED]>
> To: "Tonu Samuel"
> <[EMAIL PROTECTED]>
> Cc: "MySQL" <[EMAIL P
Samuel" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, June 13, 2002 12:14 AM
Subject: Re: table is read only when DB copied from Win to UNIX
> Thanks for the tip but I have added to the table db in
> mysql database full permission for everybody t
Thanks for the tip but I have added to the table db in
mysql database full permission for everybody to that
database. I don't think that is a permission thing
because when I add a new table, I can insert data into
that new table. Besides it does not happen when I copy
the database from UNIX to Win
On Wed, 12 Jun 2002, Francisco Reinaldo wrote:
> Fine, I can see the database, show tables works,
> selects works. The whole nine yards? Nope! I cannot
> insert any values in that database. I get the
> following error: "Table xxx is read only". I have
> checked the OS permission for that direct
This works with ONE MORE STEP:
shut down and restart the mysqld server.
Otherwise nothing happens!
Thanks all.
steve
Michael Migal wrote:
> Make sure that the files for that table not only have correct permissions,
> but also have correct owner and group. (mysql:mysql)
> I had the same write
, 2002 4:14 PM
To: James Montebello
Cc: [EMAIL PROTECTED]; MySQL List
Subject: Re: Table is "read only"
James Montebello wrote:
> File permissions?
Nope, tried that.
>
>>mysql> lock table White write;
>>ERROR 1036: Table 'White' is read only
>>
James Montebello wrote:
> File permissions?
Nope, tried that.
>
>>mysql> lock table White write;
>>ERROR 1036: Table 'White' is read only
>>
>>
>>How do we make it read-write?
--
Steve Rapaport
still at large
-
Befor
17 matches
Mail list logo