My stupidity knows no bounds, it really doesn't.
So yesterday, I found out I'd been hacked. Nothing major, just a defacement of an old folder I used to use. The whole server had been done and any folders which were writeable had files inserted and others defaced. I stupidly thought that folder would be safe since I'd password-protected it, but obviously not. Anyway, like I said - no big deal, but I decided to change all my passwords just in case. To do this for the databases, I had to delete the MySQL users and recreate them with different passwords and all that. I use cPanel for all this, so in order to delete the MySQL user, I first deleted the user from the access list for the database just in case. Of course, I clicked the wrong delete and managed to delete my entire Wordpress database. :'(
Fortunately I had a recent-ish backup (two days old) so I was able to restore everything (give or take a few comments) but still... cPanel should have a confirmation asking if you're sure you want to delete databases. Grrr. Either that or I should be more careful where I'm clicking.
On a somewhat related note, my server's time is messed up. I keep having to change the offsets and it's really annoying me. Right now it's almost an hour fast - a gmdate() function reveals the GMT time to be almost an hour fast, anyway. I asked support about it and they said they would look into it, but so far nothing seems to have changed. :(
Jem
18/05/2006 at 9:35
I already told you my story of woe when it came to accidently deleting my wordpress database back in the day..
My
gmdate()is off too, since we switched the clocks back.. or forward, or whatever it was we did. I'm having to usegmdate("Y-m-d H:i:s", time()+(3600));at the moment.. meh.Amelie
18/05/2006 at 9:39
Well up until this morning I was using something like
strtotime("+4 hours 20 minutes")which seemed to be working, but now I'm going to have to fiddle with it again to make it something like+3 hours 50 minutes. Really annoying. :(Wait, of course your
gmdate()will be off - we're an hour ahead of GMT now. My server isn't just messed up like that, it's completely wrong. Like for example now, the time here is 9:40am. The GMT time should be reporting 8:40am - it's not, it's reporting 9:25am. The actual server time, which is in American EDT time (GMT -4) is wrong too - it should say 4:40am instead of 5:25am like it's currently doing.Katy
18/05/2006 at 11:50
I never have to worry about what offset my server needs, as it's set to UK time anyway. It's great :)
Jem
18/05/2006 at 16:15
I wouldn't worry, but there's this bimbo called Amelie that mithers me every time there's a teensy error on my site ;)
strawdonkey
19/05/2006 at 18:00
Ouch! Unfortunately when loaded with options, cPanel can be a bit of an annoying mess at times.
That said, cPanel doesn't appear to have had a new revision for ages now - surely we must be due another version soon? Hopefully they'll fix things a little then, though I'm not expecting much after seeing the state of most backend software!
Allison
23/05/2006 at 0:09
Eeeek! I did that to two databases by accidnet a couple months ago ... and I had no backups. I hate cPanel. heh.
Jamie
24/05/2006 at 4:24
Oh wow, hackers suck. They need to get lifes or get laid as we were discussing on CG. Sorry Amelie :(