Closed Thread Icon

Topic awaiting preservation: Restoring SQL databases (Page 1 of 1) Pages that link to <a href="http://ozoneasylum.com/backlink?for=26859" title="Pages that link to Topic awaiting preservation: Restoring SQL databases (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: Restoring SQL databases <span class="small">(Page 1 of 1)</span>\

 
Ensellitis
Paranoid (IV) Inmate

From: Kansas City, MO , USA
Insane since: Feb 2002

posted posted 10-17-2005 23:30

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???

JKMabry
Maniac (V) Inmate

From: raht cheah
Insane since: Aug 2000

posted posted 10-18-2005 00:02

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.

.

JKMabry
Maniac (V) Inmate

From: raht cheah
Insane since: Aug 2000

posted posted 10-18-2005 00:07

this post blowed up

.

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

Ensellitis
Paranoid (IV) Inmate

From: Kansas City, MO , USA
Insane since: Feb 2002

posted posted 10-18-2005 00:18

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.)

CPrompt
Maniac (V) Inmate

From: there...no..there.....
Insane since: May 2001

posted posted 10-18-2005 01:03

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:\

Ensellitis
Paranoid (IV) Inmate

From: Kansas City, MO , USA
Insane since: Feb 2002

posted posted 10-18-2005 01:20

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.

Ensellitis
Paranoid (IV) Inmate

From: Kansas City, MO , USA
Insane since: Feb 2002

posted posted 10-18-2005 19:33

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.

Skaarjj
Maniac (V) Mad Scientist

From: :morF
Insane since: May 2000

posted posted 10-19-2005 12:02

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

Ensellitis
Paranoid (IV) Inmate

From: Kansas City, MO , USA
Insane since: Feb 2002

posted posted 10-19-2005 20:47

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

« BackwardsOnwards »

Show Forum Drop Down Menu