Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Australia
    Posts
    42

    Unanswered: Database repair tools

    I aware that MySQL is pretty reliable and its availablity is quite good.
    However, is there any tools that might help in reparing the database just in case there is some kind of table corruption ?

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: Database repair tools

    Originally posted by ManUtdFans2003
    I aware that MySQL is pretty reliable and its availablity is quite good.
    However, is there any tools that might help in reparing the database just in case there is some kind of table corruption ?
    Check the repair command:

    http://www.mysql.com/doc/en/Repair.html

  3. #3
    Join Date
    Oct 2003
    Posts
    706

    Lightbulb

    The MySQL database structure is thoughtfully designed. Each database is a directory (accessible only to the MySQL daemon), and the tables and their related indexes, etc are stored in separate disk files. This creates a disk structure quite different from the MS-Access ".MDB file," and much more conducive to repair.

    A client-server database is inherently more robust than filesever-based systems like Paradox or MS-Access, as long as you carefully observe four things:
    • Make sure that it has a good, strong UPS (Uninterruptible Power Supply) box. (Network hardware and such should also have similar equipment.)
    • Make sure to use RAID arrays, to guard against failure.
    • Make sure to back up the database diligently, and test for actual recovery ability.
    • Set up logins and permissions on the database server box correctly.
    ChimneySweep(R): fast, automatic
    table repair at a click of the
    mouse! http://www.sundialservices.com

  4. #4
    Join Date
    Jan 2004
    Posts
    24
    What I personally do is run the mysqlcheck command with the auto-repair flag on all databases via a cron script once a week. It makes sure that every if in good shape. Then I have it email me any problems.

    Donny
    http://www.phpscripts.com/

Posting Permissions

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