Frequently corrupt tables

2001-10-18 Thread Matthew Bloch
Hello all; I'm running several MySQL installation (all version 3.23.37 under Linux) under what I presume are some fairly harsh conditions, and wondered what circumstances cause tables to be corrupted and need fixing with myisamchk. This is happening once every few days and it's becoming a pain.

Re: Frequently corrupt tables

2001-10-18 Thread Matthew Bloch
On Thu, 18 Oct 2001, Kyle Hayes wrote: > On Thursday 18 October 2001 09:45, Bill Adams wrote: > > Matthew Bloch wrote: > > > I'm running several MySQL installation (all version 3.23.37 under Linux) > > > under what I presume are some fairly harsh conditions, and w

Strange duplicates error when inserting

2001-06-20 Thread Matthew Bloch
I came across this error in a script which keep track of interesting URLs, where the first column in a table is an automatically incrementing, primary-key Id field. This statement failed: mysql> insert into Matches values (0,1234,56,'http://interesting.com/', 'title', NOW(), 'New'); ERROR 1062: