If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > Database repair tools

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-20-04, 22:56
ManUtdFans2003 ManUtdFans2003 is offline
Registered User
 
Join Date: Jan 2004
Location: Australia
Posts: 42
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 ?
Reply With Quote
  #2 (permalink)  
Old 01-21-04, 01:13
bstjean bstjean is offline
Registered User
 
Join Date: Sep 2002
Location: Montreal, Canada
Posts: 219
Re: Database repair tools

Quote:
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
Reply With Quote
  #3 (permalink)  
Old 01-21-04, 11:48
sundialsvcs sundialsvcs is offline
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old 01-24-04, 15:43
donsimon donsimon is offline
Registered User
 
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/
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On