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 did "flush privileges", then logged out and logged back in to mysql as bhaselto, but I still got the error "table 'test' is read only" when trying to insert rows into it.
Any idea on how to do something differently with GRANT to make it work?
-Bennett
At 04:16 PM 8/16/2003 -0700, 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 "tracerlock" on the new server, I copied these files over to the /var/lib/mysql/tracerlock directory on the new server. On both servers, all the table files are owned by user "mysql" in the "mysql" group.
Now, when I connect to MySQL on the new machine and load the tracerlock database, "show tables" shows all the tables as expected, and I can perform SELECT statements on them and get the correct results. But when I try doing INSERT statements on one of the tables that was copied over, I get:
mysql> INSERT INTO test VALUES(3); ERROR 1036: Table 'test' is read only
However, if I create a new table called test2, I can perform INSERT statements on it with no error:
mysql> insert into test2 values(3); Query OK, 1 row affected (0.00 sec)
The files corresponding to test and test2 have the same permissions and ownership, so that's not it:
-rw-rw---- 1 mysql mysql 20 Aug 15 21:22 test.MYD
-rw-rw---- 1 mysql mysql 1024 Aug 15 21:22 test.MYI
-rw-rw---- 1 mysql mysql 8556 Aug 15 21:22 test.frm
-rw-rw---- 1 mysql mysql 5 Aug 16 19:13 test2.MYD
-rw-rw---- 1 mysql mysql 1024 Aug 16 19:13 test2.MYI
-rw-rw---- 1 mysql mysql 8556 Aug 16 19:13 test2.frm
So how do I get rid of the error that "Table 'test' is read only"?
-Bennett
[EMAIL PROTECTED] http://www.peacefire.org (425) 497 9002
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED] http://www.peacefire.org (425) 497 9002
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
