Author Topic: Why mysql server database crashes or gets corrupt  (Read 37703 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 as well learn about Search Engine Optimization, Server management and more..
Join Now!

Database Error

Please try again. If you come back to this error screen, report the error to an administrator.
Back