Webmaster's Community

Designing and Development => Programming => Topic started by: Anay on October 05, 2012, 06:55:22 AM

Title: Why mysql server database crashes or gets corrupt
Post by: Anay on October 05, 2012, 06:55:22 AM

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 ?

Title: Re: Why mysql server database crashes or gets corrupt
Post by: Savera on October 08, 2012, 06:16:48 AM

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..