Author Topic: Why mysql server database crashes or gets corrupt  (Read 37706 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?

IfandBut.com is place where you can meet serious webmasters and make new ties to grow your business.
Join Now!
anything

Database Error

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