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 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: Harrell, Roger [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 21, 2003 7:59 AM To: [EMAIL PROTECTED] Subject: Recovering data from ISD/ISM/frm files
I need to restore a table from backup copies of the ISD/ISM/frm files. I can't seem to get it to work. I have copied over the files, I have tried restoring using isamchk. I'm sure it has something to do with the temporary tables, but I can't find anything in the docs about this. All I keep getting is the current messed up data. I have a clean backup from earlier today, but can't get them to restore. Any thoughts/help appreciated.
Thanks, Roger
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
