MySQL Forums
Forum List  »  PHP

Re: corruption problem on power loss
Posted by: Barry Galbraith
Date: March 10, 2015 09:10PM

>Is it because of open connections to database?

Probably not. More likely because table data is held in ram, and only written to files when nothing else is happening.
Power loss results in loss of the data held in ram and not written to files.
Restore your database from your backup, and use your binary log to return your database to the point it was at when the power failed.

You do have a backup, don't you?

Good luck,
Barry.

Options: ReplyQuote


Subject
Written By
Posted
Re: corruption problem on power loss
March 10, 2015 09:10PM


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.