Hi, i encountered some problem with table: ERROR 1030: got error 1030 from table handler
i found many solutions, how to temporarily fix it (myisamchk), but it appears again and again and makes our server unusable. so, the question is 'what can CAUSE it' and how to repair it forever? the machine is: intel celeron@400 with 256mb ram avgload: 0.05 0.03 0.00 1/54 24647 redhat 7.2 Linux version 2.4.13 (***) (gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)) #1 Thu Oct 25 03:07:55 CEST 2001 mysql 3.23.41 the table, which gone damaged: CREATE TABLE counter ( id int(11) NOT NULL auto_increment, counts int(11) NOT NULL default '0', name varchar(80) NOT NULL default '', pridano datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id,name) ) TYPE=MyISAM; does anybody know the answer? thank you JS -- jakub suchy [ [EMAIL PROTECTED] ] "Those who would give up a little freedom for a little safety, deserve neither freedom nor safety." --Benjamin Franklin --------------------------------------------------------------------- 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