On 11 2 , 8 16 , gordonb.qj...@burditt.org (Gordon Burditt) wrote:
rare case, if InnoDB table was corrupted, there

> In a true Worst Case Scenario, you don't get back anything. Your
> server suffers a power surge (it got through the UPS, perhaps because
> it was an EMP from a terrorist nuke) and goes down, frying electronics
> in the process. You power it back up again, a fire starts, and the
> resulting fire takes out all your hardware, all your on-site backups,
> and all the people involved with the application.

snipped.

Anyway, to make it more simple:


1. Will there be a case such that, if my table is using MyISAM, it can
be recovered, but now it can't as I am using InnoDB?

2. Will there be a case such that, if my table is using InnoDB, it can
be recovered, but now it can't as I am using MyISAM? (except the
reason InnoDB didn't corrupt...usually)

Thanks.