SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    Non-Member slr's Avatar
    Join Date
    Oct 2013
    Posts
    6
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to auto fix crashed table?

    Hello,

    from time to time happens that an mysql table is marked as crashed and so website dont work properly.

    I want to ask what is the smartest way to fix this issue without big downtime? Any script that checks mysql and auto fix crashed table or any script which notiffy admin via email?

    i got idea somehow extracting mysqld.log entries and if match email is sent, but im not good programmer so i ask advice

  2. #2
    Programming Team silver trophybronze trophy
    Mittineague's Avatar
    Join Date
    Jul 2005
    Location
    West Springfield, Massachusetts
    Posts
    17,188
    Mentioned
    191 Post(s)
    Tagged
    2 Thread(s)
    Assuming you are talking MySQL (if not, please specify), you won't need a script, MySQL has this built in.
    http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
    https://dev.mysql.com/doc/refman/5.0...ng-tables.html


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •