Replication errors

Hi I've got a master and a slave both at 3.23.49. I've been running replication for the last 3 months and all of a sudden I've got queries failing on the slave with duplicate entries (error 1062). From the documentation all I can figure out is that there's a possibility I might be using differen

RE: What would be an efficient way to accomplish this ( Statistic s/Trends in a table?) Thanks!

Paul How about select FIRST_NAME, count(*) from a table group by FIRSTNAME having count(FIRST_NAME) > 1 Mike -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person

RE: Check for data before inserting

Traditionally, I'd take the following approach 1) Update - assume it's there 2) If update fails (0 rows) do an insert Thats assuming that the update case is more prevalent. If the row is unlikely to be there - insert and do the update if you get a duplicate key. Rgds Mike -Original Me

RE: I can't figure out what I thought would be a simple query..

Okay - I can't figure this out as a single sql statement. However Assuming there aren't likely to be duplicate rows you could do: create table temp2 (table definition) select max(endtime), non_unique_id temp1 group by non_unique_id; then you could select a.endtime, a.need_id, b.unique_id fro

Download MySql 4.05 for HP-UX

Folks I'm trying to download 4.05a-beta for HP-UX 11.00. However I select the file and go of to the sites to be told i'm trying to download binaries for HP-UX 10.20. Anyone know where I can get the correct binaries for 11.00 ? Rgds Mike E-mail: [EMAIL PROTECTED] /mysql sql -

RE: Index usage vs table scanning

MySQL performance query. I've got a puzzle which is as follows: I've got a new table which I'll be loading with approx 1 million rows per day. This is being loaded from a C program which seems to work fine. The table being loaded is as follows: | Field | Type| Null | Key