Author Topic: Why mysql server database crashes or gets corrupt  (Read 9057 times)

Anay

  • Newbie
  • *
  • Posts: 32
Why mysql server database crashes or gets corrupt
« 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 ?

Savera

  • Full Member
  • ***
  • Posts: 159
Re: Why mysql server database crashes or gets corrupt
« Reply #1 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..

 

X

Do you know?

By participating in our community you can get free Top Level Domain for lifetime.
Know more..
Join Now!