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 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
