Mark Papadakis wrote:
> We are using mySQL on over 6 servers here, we have been doing so for over 2 years,
>and we are constaly facing problems with corrupted tables, especially on two of our
>busiest servers.
> Tables seem to corrupt out of the blue and we have to shut them down ( the servers )
>occassionaly to fix all tables and then bring them up again.
I have found that sometimes (esp. with older versions of MySQL which is not the case
for you) that the only way to either repair or permanently repair a table is to
dump/drop/reload the table and data. I had some instances a number of years back
where the table would
repair and be okay with isamchk but would, at a random time, be corrupted again.
Doing the dump, etc. fixed the problem.
--Bill
---------------------------------------------------------------------
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
