I've built a java application which updates my mysql database with data retrieved off the local network. the mysql server is on a remove vps.
unfortunately there was a a little problem and the local pc running the program died with the windows blue screen (its a fairly old pc only used for running the program).
anyway the real problem is after i has going through some of the data i found one record (last one inserted) was replicated about 1000+ times.
I thought it odd and deleted all the replicated rows. a few minutes later another check found the same record still duplicating after a count last showed 0.
i ran this query
COUNT(ikey) AS numberOfEntries
GROUP BY ikey
HAVING ( COUNT(ikey) > 1 );
it showed about 20 records when i first started writing this post and just ran it now its showing just over 100.
Can anyone suggest anything to stop this please.
I've tried rebooting the mysql server then rebooting the whole vps but it just continues...
any ideas anyone?