Topic awaiting preservation: Restoring SQL databases (Page 1 of 1)

I just had a script delete every thing in my database, a collection of 5 years of work... Is there ANYWAY to restore the database???

if you have abackup of the SQL you can put it back easy enough, are you asking the Asylum if we have a backup of your data? Sorry to take a shot in your time of need.

Seriously, got backup? If not, does your host have one they can restore? Host surely does. Dreamhost has snapshot backups for your user spaces where you can backup to a state from minutes to weeks ago but there's no such thing in place for SQL, that's a manual backup (have a script dump/zip deposit in user space at intervals) thing although support can restore from *their* backups if you ask nicely. That said, if I recall, you're not with DH, but I say it cuz your host may have something similar in place.

In short, if you don't have the SQL dump, ask your host nicely to restore it for you (some charge for such services).

Hopef 5 years isn't gone, that'd be sick.

.

this post blowed up

.

(Edited by JKMabry on 10-18-2005 00:20)

I eamiled my host, it takes about 2 hours for a reply. And yes, I am retarded for not making backups, if I get my site back, then I will be sure to back it up atleast every few days.

It's ok to monkey around... I need to smile, for the past 20 minutes I have been shaking from being so pissed off. I still have your email address from the shoutbox you sent me, I never throw anything away (But I never back it up.)

your host should have a backup of your database. do you have an admin panel that you can log onto from their site?
The host that I go through has what they call an "ops" page to get to everything on the site. Kind of a site manager I guess. From there I can get backups of all the database's and they keep them from one week out and just rotate them.

Later,

C:\

After contacting them, i gave them them the exact date and time this happened... So it's just a waiting game now. All i can hope is that they aren't a crappy host and actually make backups... Even if it is 5 months old, it's better then totally losing everything.

I was able to get a back up that was a week old... Thank god they ctually had it. From now on, I will be backing up fairly often. I guess it takes something like this to learn a listen like that.

If you have shell access to your site I'd suggest you make a little PHP script that accesses ytour database and dumps it all out to an SQL file in your user space, perferably in a directly only you can access. Set that up to run as a cron job every day at a random interval ±, say, midnight., or every couple of days, or something. And then on, say, a friday, get it to make a copy and email it to you, to an address that gets downloaded to your computer.


Justice 4 Pat Richard

Great idea. I will do that right now. Thanks alot!