Check the ownership and permissions on the files.
Since you copied them over, perhaps they are owned by root, and not mysql.
You did shut down the server before copyng the files?
Harrell, Roger wrote:
Ok, well I have managed to recover the data from my backup, but now when I
try to update the tabl
Ok, got it worked out. I had to dump, drop and recreate the table, but it's
working.
Roger
-Original Message-
From: Harrell, Roger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 21, 2003 8:49 AM
To: [EMAIL PROTECTED]
Subject: RE: Recovering data from ISD/ISM/frm files
Ok, well I
Ok, well I have managed to recover the data from my backup, but now when I
try to update the table, or insert rows I get the error:
table 'tablename' is read only.
trying to unlock the table doesn't seem to help. I have stopped and
restarted mysql.
Thanks,
Roger
-Original Message-
From: