Pada Thu, 12 Sep 2002 22:22:24 +0000
"Inandjo Taurel" <[EMAIL PROTECTED]> menulis :
> sqlsqlsqlsqlsqlsqlsqlsqlsql
>
>
> hi ,
>
> I've been having a constant nightmare for the past 2 weeks: a particular
> table gets corrupted every at least twice.
> Am using the 3.23.49 windows version and Myisam table types on Win2k, and
> the operation crashing the database seems to be an update.
> I get an error 127 (table handler) and when i check the table it tells me
> that the number of records is wrong.
> How can i stop that particular table from being corrupted so often??
> What should i do??
You should check on your <hostname>.err file,
if you find something like mysql restarted,
or maybe even you PC restarted / rebooted not in proper way (without shutting down
mysqld properly) ...
then you should solve the restarting problem.
but for preventive action, you can create a scheduled job/task for repairing your
tables.
--
Write clearly - don't be too clever.
- The Elements of Programming Style (Kernighan & Plaugher)
MySQL 3.23.51 : up 2 days, Queries : 459.342 per second (avg).
--
Dicky Wahyu Purnomo - System Administrator
PT FIRSTWAP : Jl Kapt. Tendean No. 34 - Jakarta Selatan 12790
Phone: +62 21 79199577 - HP: +62 8158787286 - Web: http://www.1rstwap.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
