Designing and Development > Programming

Why mysql server database crashes or gets corrupt

(1/1)

Anay:
Hi

I have smf forum installed and it got corrupt and then I saw corrupt message. I repaired it from tool in cpanel and it is working fine now but I wonder why this happens and what I can do to avoid and prevent this in future ?

What can I do at my level to avoid this in future or I need to get help of my webhost for this ?

Savera:
Database can get corrupt for any of the following reason :

  The mysqld process is killed in the middle of a write.

    An unexpected computer shutdown occurs (for example, the computer is turned off).

    Hardware failures.

    You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same time.

    A software bug in sql program itself..

Navigation

[0] Message Index