MySQL Forums
Forum List  »  Merge Storage Engine

Re: storage engine error
Posted by: Alexandre BLANC
Date: August 29, 2007 10:07AM

i had the same error 124 with a merge table, but repair nor repair use_frm could fix the problem...
The .FRM of some tables used in the merge was corrupted ! So, i create a new table, insert the data inside and destroy the corrupted one. If the data couldn't be read, it's necessary to stop mysqld, replace the .frm corrupted by the new one, then restart mysqld and repair use_frm the table to rescue the data.

The merge table works properly now.



Edited 1 time(s). Last edit at 08/30/2007 02:28AM by Alexandre BLANC.

Options: ReplyQuote


Subject
Views
Written By
Posted
25836
August 17, 2005 04:05PM
12151
August 18, 2005 03:29AM
13285
January 19, 2006 07:34AM
13158
January 20, 2006 03:55AM
9900
April 18, 2006 02:18AM
8875
March 05, 2007 07:26AM
Re: storage engine error
8144
August 29, 2007 10:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.