hi together, we have small problems with a commercial used mysql-database under windows nt 4.0 sp6. the used version of mysql ist 3.22.30. the communication between database and our software ist running with the belonging ODBC-Driver. the complete software is running at only one pc. our software is using only insert and delete commands. At the moment we're certain, that the problem is not caused from our software. meanwhile database-size is growing up to 600 mb. every day we're inserting nearly 75.000 records. sometimes (once, twice a week) our software is stopping, because there's suddenly a damaged table in the mysql-database. isamchk is reporting always the same mistake: Checking ISAM file: tean Data records: 84017 Deleted blocks: 0 - check file-size - check delete-chain - check index reference - check data record references index: 1 isamchk: error: Found key at page 4459520 that points to record outside datafile ISAM-table 'tean' is corrupted Fix it using switch "-r" or "-o" repairing the table ist no problem, but it shouldn't be the normal way. i have no idea, how to fix the problem. perhaps you... thanks and bye mike --------------------------------------------------------------------- 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
