strange happenings in mysql 5

[twiSSt]

I have some strange things going on with my db's. To start last monday i arrived at work and was informed that all of the data from friday was gone and it looked like the last date for updated/new data was on monday of that week.

It was as though someone restored our data back to the 10th. Thankfully i have setup good backups and was able to restore most of the data.

Today on of my databases magicaly lost about 24 records, again i was able to mrestore the orginal data but 2 instances like this in a week are cause for worry.

We are using 5.0 on a win 2003 server and the frontend for the db's is written in cold fusion.

We are a BtoB call center and this application is set up to automate the process of building a script for our staff to call from. There is nothing in the CF code that would delete any records. addittionaly there is nothing set up on the server to restore to any specific date or point in time.

as for users, we are pretty tight about who can do what and who has access, when we created the application we created a user - application - with a limited set of privleges, production user - cannot delete records and myself who is the "super" user.

I am coming up against a wall to explain how this could happen and am open to suggestions or ideas. My gut feeling is that somebody is doing this rather than it happening via software/hardware.

Twist

===========================================
Everything will be OK in the end.
If it's not OK, then it's not the end

 

[audiopro]

Are the records actually being deleted?
I ask this because I had an EPOS system(not MySQL but another flavour of dB) that did the same thing.
Fault was the date var was set to 0 by another process and all the new records for one day were ordered to the start of the table. The following day when I was called in, the new records were in the right place.

Keith

http://www.studiosoft.co.uk

 

[twiSSt]

In the first instance, yes it appears that the records were infact deleted. when i came in to work on the 17th the data was reflecting the 10th.

I use MySQl auto backup - which does have a restore function, so i guess someone could have actually created a restore script and performed a backup, which is really kind of frightning.

I was able to go to my back up and restore it back to friday the 14ths dataat about 1:00 in the afternoon.

in the second instance, the application we have built has a table called questions. it carries the question text for a survey and those were completly deleted.

Twist

===========================================
Everything will be OK in the end.
If it's not OK, then it's not the end