Re: Innodb Table Recovery

[Rick James]

> Was dropping the index the cause of the inndob crash?
Very unlikely. Did anything else happen about the time of the "crash"?

> I was trying to drop the primary key
Don't do that. InnoDB tables must have a PK. If you need to change the PK, do this:
ALTER TABLE foo
DROP PRIMARY KEY,
ADD PRIMARY KEY(x,y);
That is, do the DROP and ADD in a single ALTER. In general, it is best to do all ALTERs in a single statement.