database emptied by accident

 
    Posted On: 23 Nov 2007 10:33 PM
Hi,
website is hotel-a-to-z.com, i have a directory there, and categories of this directory jos_jvse_categories in the db has been emptied all of a sudden... I dont know exactly when because i saw it yesterday and had not looked at it for a week.
I've talked with the component's developper and he guaranteed that such a deletion is impossible from the interface (front or backend coz the soft cant' delete categories if not empty and they are not) and that it must come from the database's server.
So I'm turning to you... I had some problems recently with the server writing some corrupt script, could that be the same problem?

Please tell me how such a major problem can happen and if there is a way to prevent these things in the future?


    Posted On: 23 Nov 2007 10:39 PM
Does anyone else have your Cpanel password?

In order for them to delete a table, they would need one of 2 things, either have the database username and password OR they would need to have the Cpanel username and password.

Please let us know if we can further assist you.
Thanks,

    Posted On: 27 Nov 2007 01:15 AM
hi,
sorry for late reply, i was away for a couple of days.
No, i dont think anybody has access to my cpanel
the very strange thing is that the table was not dropped, just the content disappeared... there were over 2000 lines in that categorie...
i thought it was coming from a server writing error like it happened last week on another of my website (forgot the ticket id of that one)
i'm very sorry to bother u that often nowdays, but it's true that i got strange things happening with ur server the past month.
I can just reload the categories for that website is still in construction, but about to be completed and i cant afford to have that happen again for i will list several thousands hotels in it
i just need to understand WHY so i can avoid it in the future
thanks for ur time
kindly

    Posted On: 27 Nov 2007 01:20 AM
Hello,

Did you have a ticket in to restore this account from backups, perhaps? There is no general query logging set up for MySQL, due to the size of such a log and performance constraints, so it's not possible to tell what queries were executed against this DB specifically (such an unqualified DELETE FROM against on of your tables). However, all DBs are backed up daily as part of the your account backups.

    Posted On: 27 Nov 2007 01:31 AM

links that were entered later than the categories are still there, so if there'd been a restore, links would be gone.
well, let's just make a note of that incident, i'll reload the cats, hoping it will not happen again.
It's just that i'm starting to handle websites taht are increasingly serious (and they're not mine), so i feel a little bit unsecure with all the things that have happened recently (and i really think that it's not a manipulation mistake from my part).
luckily your support team is kind and helpful.
thanks for ur time.Matthieu


    Posted On: 27 Nov 2007 01:39 AM
Hello,

This could have been through a script on the server which has access to your database (ie, through your application itself) but otherwise the only accesses to phpMyAdmin for this account appear to be IPs consistent with your location:

1 125.27.72.36
1 125.27.74.118
1 125.27.77.182
1 125.27.92.11
66 125.27.73.74
148 125.27.75.142
98 125.27.75.194

You can set up more frequent MySQL backups via a cron job for additional piece of mind.

 

it appears that refreshing a mysql page after a query is a very bad idea and can lead to major fuckups ^_^ 

This website uses Cookies