Michael Blood wrote: > I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram. > > I have been getting an table handler returns error 127 error > > If I fix the table with myisamchk -r or -o it will work for a while and then > I will get the same error again.
Try dumping and restroing the table. (backup your database files) mysqldump --add-drop-table -q db table >tmp.sql (possibly remove the table.* files here) mysql db <tmp.sql You may also want to either start mysqld with the flush option or run the SQL "FLUSH TABLES" before a program exit or occasionally while running. b. --------------------------------------------------------------------- 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