> $ perror 144 > 144 = Table is crashed and last repair failed > > Your table is corrupted, try to repair it with REPAIR TABLE or > myisamchk: > http://www.mysql.com/doc/en/Repair.html
Hmm. REPAIR TABLE gives | mydb.IDRefs | repair | error | Can't create new tempfile: './mydb/IDRefs.TMD' | | mydb.IDRefs | repair | status | Operation failed | However, myisamchk -r IDRefs worked OK. > JP> optimize table IDRefs; > JP> "Can't open file: 'IDRefs.MYD'. (errno: 13)" > MySQL server doesn't have permissions on that file ... This I have fixed. > JP> I have changed the query to INSERT DELAYED in case too many clients are > JP> locking the table, should I change it back? > > Did you install MySQL server from binary or from source? >From sources. 3.23.51 on Solaris. --------------------------------------------------------------------- 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
