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 is set
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
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)
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 was
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 password
and that didn't work when I did it, but I didn't restart mysql after
running the command. Probably it
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 called
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 the
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 password
I tried that, and then
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
434 7582
- Original Message -
From: Francisco Reinaldo [EMAIL PROTECTED]
To: Tonu 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
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 directory
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
[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 to that
database. I don't think that is a permission thing
because when
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
-
Before posting,
, 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
How do we make it read-write?
--
Steve Rapaport
still
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
16 matches
Mail list logo
