BIG Link O'Rama Database Problem

Greenguy · 2006-02-24, 11:51 AM

Well, this is one way to cut down on the number of links that I have listed

Yesterday afternoon, while doing a search & replace on the database, I somehow lost about 10 months worth of accepted links

National Net should have a back up copy, but if it's from last night, I'm sorta screwed

Seeing as I was a complete idiot & didn't back up the database before I tinkered with it, if Nat Net doesn't have a copy that over 24 hours old, the one that I do have is from late January, so worst case scenario is that I've lost a months worth of links

I'll keep everyone posted

Greenguy · 2006-02-24, 11:55 AM

I'm fucked.

Nat Net did a back up about an hour ago, which means that had I found out that I fucked this up a little earlier, I'd have been ok

FUCK FUCK FUCK FUCK FUCK

I think I might be able to salvage & re-review the last month's work of submits, so you know what I'll be doing all afternoon.

stuveltje · 2006-02-24, 11:59 AM

i am glad i am not the only one who can fuck up links in database, lol i am sorry gg but it gives me a good feeling others can make mistakes too

i hope you get all fixed soon

Preacher · 2006-02-24, 12:00 PM

Ouch, sorry to hear that GreenGuy!

Surfn · 2006-02-24, 12:00 PM

Ya gotta hate when shit like that happens. Good luck getting things restored

Cleo · 2006-02-24, 12:03 PM

That sucks

I have shell scripts on my server that does nightly dumps of all my databases to seven different files one for each day of the week so I always have seven days worth of backups of all my databases. Plus I use rsync to keep a local copy of my server on my laptop and I archive that about once a week to a firewire drive so I also have multiple complete backups of all my domains and databases. I'm just really paranoid about losing stuff.

Think positive. It's always easer to do something the second time.

MrYum · 2006-02-24, 12:12 PM

Oh damn...that bites the big one Greenie

Best of luck on the repairs

stuveltje · 2006-02-24, 12:13 PM

my host or script i realy dont know how that works, but it makes an automaticly(or whatever you name that) back up of the database everyday, only not al the linksites i do have that

Greenguy · 2006-02-24, 01:45 PM

National Net To The Rescue!!!!!!!!

They found some older copies & one was from yesterday....the exact copy I started to fuck with

So I just have to throw today's links into that copy & upload it & I should be all set.

stuveltje · 2006-02-24, 01:48 PM

Quote:

Originally Posted by Greenguy

National Net To The Rescue!!!!!!!!

They found some older copies & one was from yesterday....the exact copy I started to fuck with

So I just have to throw today's links into that copy & upload it & I should be all set.

well there you go

not everything looks that bad as you think.......did i say that right

RawAlex · 2006-02-24, 01:55 PM

GG, you are a lucky man on this one. I have had similar experiences in the past, and damn, it sucks.

Alex

Greenguy · 2006-02-24, 02:03 PM

It looks like I lost all the submits from Feb 22nd

But all things considered, I'll take loosing a day's worth of submits over 10 months of listings

Torn Rose · 2006-02-24, 02:08 PM

was ya stressing?

Cleo · 2006-02-24, 02:08 PM

Wow you get to have all the fun…

Greenguy · 2006-02-24, 02:13 PM

Stressing? Nah. I have a MrMaryLou

stuveltje · 2006-02-24, 02:17 PM

Quote:

Originally Posted by Greenguy

Stressing? Nah. I have a MrMaryLou

poor mml

tigermom · 2006-02-24, 02:42 PM

Gotta love databases, backups and all that shit. Best part of this job isn't it?

NOT!

Jim · 2006-02-24, 02:44 PM

I had hopes they had a copy or two

virgohippy · 2006-02-24, 03:49 PM

I hate to be a pest about this, but if I have a site which was listed, and now is not, how should I tell you?

MrYum · 2006-02-24, 04:12 PM

Great stuff...congrats Greenie! Bet that's one helluva load off off the brain

WTG NatNet

Greenguy · 2006-02-24, 04:57 PM

Quote:

Originally Posted by virgohippy

I hate to be a pest about this, but if I have a site which was listed, and now is not, how should I tell you?

Just resubmit it please.

plateman · 2006-02-24, 05:13 PM

good to hear GG and a nice trade off...

swedguy · 2006-02-24, 07:13 PM

Here's a link that will save you from future headache

http://worldcommunity.com/opensource...ql_backup.html

MeatPounder · 2006-02-24, 07:57 PM

Note to MrMaryLou...do NOT let the Greenguy near the Databases again

2006-02-24, 11:51 AM	#1
Greenguy The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep Join Date: Feb 2003 Location: Blasdell, NY (shithole suburb south of Buffalo) Posts: 41,929	BIG Link O'Rama Database Problem Well, this is one way to cut down on the number of links that I have listed Yesterday afternoon, while doing a search & replace on the database, I somehow lost about 10 months worth of accepted links National Net should have a back up copy, but if it's from last night, I'm sorta screwed Seeing as I was a complete idiot & didn't back up the database before I tinkered with it, if Nat Net doesn't have a copy that over 24 hours old, the one that I do have is from late January, so worst case scenario is that I've lost a months worth of links I'll keep everyone posted __________________ Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network

2006-02-24, 11:55 AM	#2
Greenguy The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep Join Date: Feb 2003 Location: Blasdell, NY (shithole suburb south of Buffalo) Posts: 41,929	I'm fucked. Nat Net did a back up about an hour ago, which means that had I found out that I fucked this up a little earlier, I'd have been ok FUCK FUCK FUCK FUCK FUCK I think I might be able to salvage & re-review the last month's work of submits, so you know what I'll be doing all afternoon. __________________ Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network

2006-02-24, 11:59 AM	#3
stuveltje Live and learn. And take very careful notes! Join Date: Apr 2003 Location: Sunny Holland Posts: 6,157	i am glad i am not the only one who can fuck up links in database, lol i am sorry gg but it gives me a good feeling others can make mistakes too i hope you get all fixed soon __________________ Canadian Sexlinks - submit Erotica search -submit

2006-02-24, 12:00 PM	#4
Preacher There's Xanax in my thurible! Join Date: Apr 2005 Location: Wherever they screw on my head Posts: 2,441	Ouch, sorry to hear that GreenGuy! __________________ NSCash * This Depraved World

2006-02-24, 12:00 PM	#5
Surfn If you don’t take a chance the Angels won’t dance Join Date: Aug 2003 Location: Earth on occasion Posts: 8,812	Ya gotta hate when shit like that happens. Good luck getting things restored __________________ Surfn's Links Are you a partner?

2006-02-24, 12:03 PM	#6
Cleo Subversive filth of the hedonistic decadent West Join Date: Mar 2003 Location: Southeast Florida Posts: 27,936	That sucks I have shell scripts on my server that does nightly dumps of all my databases to seven different files one for each day of the week so I always have seven days worth of backups of all my databases. Plus I use rsync to keep a local copy of my server on my laptop and I archive that about once a week to a firewire drive so I also have multiple complete backups of all my domains and databases. I'm just really paranoid about losing stuff. Think positive. It's always easer to do something the second time. __________________ Free Rides on Uber and Lyft Uber Car: uberTzTerri Lyft Car: TZ896289

2006-02-24, 12:12 PM	#7
MrYum Arghhhh...submit yer sites ya ruddy swabs! Join Date: May 2004 Location: Sunny Florida! Posts: 5,108	Oh damn...that bites the big one Greenie Best of luck on the repairs __________________ Porno Flixxx Submissions SOTI Site Submissions Free Porn Resource Submissions

2006-02-24, 12:13 PM	#8
stuveltje Live and learn. And take very careful notes! Join Date: Apr 2003 Location: Sunny Holland Posts: 6,157	my host or script i realy dont know how that works, but it makes an automaticly(or whatever you name that) back up of the database everyday, only not al the linksites i do have that __________________ Canadian Sexlinks - submit Erotica search -submit

2006-02-24, 01:45 PM	#9
Greenguy The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep Join Date: Feb 2003 Location: Blasdell, NY (shithole suburb south of Buffalo) Posts: 41,929	National Net To The Rescue!!!!!!!! They found some older copies & one was from yesterday....the exact copy I started to fuck with So I just have to throw today's links into that copy & upload it & I should be all set. __________________ Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network

2006-02-24, 01:55 PM	#11
RawAlex Took the hint. Join Date: Mar 2003 Posts: 5,597	GG, you are a lucky man on this one. I have had similar experiences in the past, and damn, it sucks. Alex

2006-02-24, 02:03 PM	#12
Greenguy The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep Join Date: Feb 2003 Location: Blasdell, NY (shithole suburb south of Buffalo) Posts: 41,929	It looks like I lost all the submits from Feb 22nd But all things considered, I'll take loosing a day's worth of submits over 10 months of listings __________________ Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network

2006-02-24, 02:08 PM	#13
Torn Rose "Faith is believing what you know ain't so." ~ Mark Twain Join Date: Aug 2003 Location: Portland, Oregon Posts: 4,806	was ya stressing?

2006-02-24, 02:08 PM	#14
Cleo Subversive filth of the hedonistic decadent West Join Date: Mar 2003 Location: Southeast Florida Posts: 27,936	Wow you get to have all the fun… __________________ Free Rides on Uber and Lyft Uber Car: uberTzTerri Lyft Car: TZ896289

2006-02-24, 02:13 PM	#15
Greenguy The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep Join Date: Feb 2003 Location: Blasdell, NY (shithole suburb south of Buffalo) Posts: 41,929	Stressing? Nah. I have a MrMaryLou __________________ Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network

2006-02-24, 02:42 PM	#17
tigermom You can now put whatever you want in this space :) Join Date: Dec 2005 Posts: 893	Gotta love databases, backups and all that shit. Best part of this job isn't it? NOT! __________________ XLEF

2006-02-24, 02:44 PM	#18
Jim Banned Join Date: Aug 2003 Location: Mohawk, New York Posts: 19,477	I had hopes they had a copy or two

2006-02-24, 03:49 PM	#19
virgohippy Madness is like gravity. All it takes is a little... push. Join Date: Feb 2006 Location: California Posts: 1,679	I hate to be a pest about this, but if I have a site which was listed, and now is not, how should I tell you?

2006-02-24, 04:12 PM	#20
MrYum Arghhhh...submit yer sites ya ruddy swabs! Join Date: May 2004 Location: Sunny Florida! Posts: 5,108	Great stuff...congrats Greenie! Bet that's one helluva load off off the brain WTG NatNet __________________ Porno Flixxx Submissions SOTI Site Submissions Free Porn Resource Submissions

2006-02-24, 05:13 PM	#22
plateman What can I do - I was born this way LOL Join Date: Oct 2003 Location: ohio Posts: 3,086	good to hear GG and a nice trade off... __________________ Submit to: Porn O Plenty XXX Links Reality Here

2006-02-24, 07:13 PM	#23
swedguy Vagabond Join Date: Aug 2003 Posts: 2,374	Here's a link that will save you from future headache http://worldcommunity.com/opensource...ql_backup.html

2006-02-24, 07:57 PM	#24
MeatPounder Women might be able to fake orgasms But men can fake whole relationships Join Date: Oct 2003 Location: Fort Lauderdale, Fl Posts: 2,408	Note to MrMaryLou...do NOT let the Greenguy near the Databases again