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
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 tracerlock on the new
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