From: Dmitry Lenev Date: September 12 2012 4:10pm Subject: Re: Schema inconsistency after inplace alter table in MySQL 5.6.6-m9 List-Archive: http://lists.mysql.com/internals/38586 Message-Id: <20120912161048.GA29234@jubjub> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Hello Rich! * Rich Prohaska [12/09/12 18:55]: > Hello > > How does one recover from crashes that occur when altering a partitioned table, > especially if the operation is committed on the storage engine but the frm is old? The only way that comes to my mind is to finish .frm renaming manually (i.e. by manually renaming .frm files on disk). But, indeed, this is not a satisfactory solution for normal users and a better solution is necessary (e.g. automatic recovery/redo in some form). -- Dmitry Lenev, Software Developer Oracle Development SPB/MySQL, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification