Patrick,
Tuesday, March 19, 2002, 5:33:31 AM, you wrote:

PH> When I periodically do myisamchk -s *.MYI,
PH> it sometimes complains that some tables are corrupt.
PH> Is there any way to keep mysql tables healthy? What are the reasons to
PH> cause the table corruption?

There are different causes of table corruption. You can find some of
them if you look at:
     http://www.mysql.com/doc/C/o/Corrupted_MyISAM_tables.html

Please, check also the following link; it will be useful for you too.

You can find info about database backups, restoring and checking
tables at:
     http://www.mysql.com/doc/D/i/Disaster_Prevention.html

PH> Thanks.




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to