Re: Recovering data from ISD/ISM/frm files

2003-10-21 Thread gerald_clark
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

RE: Recovering data from ISD/ISM/frm files

2003-10-21 Thread Harrell, Roger
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

RE: Recovering data from ISD/ISM/frm files

2003-10-21 Thread Harrell, Roger
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: