Post Resurrection

[Zilch]

ACK!!

We tried to correct one of the links in post #2 of the "Quick & Dirty Contents" thread, and it self-destructed.

Can that be recovered from the server backup, please, and the correction made?

I've PM'd John and eMailed the Webmaster.

Distraught Zilchster

[4313B]

Who is this "we"?

And

I fixed it.

I fixed post #1 too.

[Zilch]

Thanks for trying, Giskard, but there were about 50 lines in that post covering the entire "Part II" thread.

"We" is me and a Moderator, as I have no access beyond the original 24 hours when it was posted....

[4313B]

Ah! That stinks big time. I was wondering why only two links.

Always cut and paste anything of importance into notepad (or something similar) as backup while you work on these forums.

If they did a backup they should be able to get the contents of the post back.

*****

Your post #2 must have been pretty recent because I just checked Google for a cached copy and there isn't one.

[Zilch]

Both parts were posted the same night.

Hopefully, it can be recovered from the server.

It'll take me most of a day to recreate it, otherwise.

I doubt I have even a printed version of it here, let alone the links....

[Zilch is STOOPID! ]

[4313B]

I just checked Yahoo and MSN also for cached copies. I guess it's up to Ann and John at this point.

Sorry!

[Zilch]

O.K., well, thanks for continuing to try helping.

I must have SOMETHING saved here, since I now recall originally working from a printed and hand-edited draft....

[John Nebel]

Backup is run in the early evening. Whatever you want from backup has to have been in the MySQL database at that point in time.

Clearly we need the date and specific information as to what it was.

[Zilch]

Hi, John.

It's this thread:

http://audioheritage.org/vbulletin/s...ead.php?t=9901

This post:

http://audioheritage.org/vbulletin/s...76&postcount=2

There were originally about 50 lines with links there. We lost all but a couple of them trying to edit one of the links.

So, if you could restore the 3/15/06 original and edit the one incorrect link (details in PM,) it'll be fixed.

Any backup since 3/15/06 should have the original. It was never otherwise edited since then, except for the recent disasterous attempt....

[John Nebel]

Ever since 3/15 but before what date?

[Zilch]

We messed it up on 4/13/06 at about 5:30 PM PDT, looks like....

[John Nebel]

OK, I'm retrieving all of vBulletin as of:

Apollo # vrestore -i -f /dev/tape/tape9
vrestore: Date of the vdump save-set: Wed Apr 12 18:45:39 2006
vrestore: Save-set source directory : /ah-vBulletin
vrestore: Target directory : /usr/users3
(/) add heritage
(/) add heritage2
(/) extract

You might be amused at:

"To restore a thread, the following tables may be affected:

forum (The threadcount field will need to be incremented.)
attachment
post
posthash
post_parsed
editlog
moderation
moderatorlog
subscribethread
reputation (probably not used)

Do a dump of each table separately (e.g. to postdump, etc)

Obtain list of postids with the threadid from the backup, and use that in the
perl get*.pl programs to pull out relevant insert lines. Some tables are small
enough to just be edited instead.

Beware of binary data in attachments, need to use the getattachment.pl program.

In that program, you'll be using a list of relevant attachmentids instead of postids.

Lump the outfiles into an sql file with insert statements. Might want to test
on a copy of the live database dumped and loaded into a separate location.

Go in and update the thread count in the forum by hand."

I'll ask Ann to look at it later.

[Zilch]

YIKES!

I'll NEVER do it again. I promise....

[Maybe Ann can tell us what we did wrong?]

[4313B]

[Maybe Ann can tell us what we did wrong?]

Anyone who's ever worked on computers can tell you what you did wrong. You didn't save before editing. SOP.

[John Nebel]

Restored! The link is fixed too.

Ann

On Sun, 16 Apr 2006, John Nebel wrote:

Ann,

4/14 JBL MySQL files are on /usr/users3


"Hi, John.

It's this thread:

http://audioheritage.org/vbulletin/s...ead.php?t=9901 (not a real link)

This post:

http://audioheritage.org/vbulletin/s...76&postcount=2 (not a real link)

There were originally about 50 lines with links there. We lost all but a couple of them trying to edit one of the links.

So, if you could restore the 3/15/06 original and edit the one incorrect link (details in PM,) it'll be fixed.

Any backup since 3/15/06 should have the original. It was never otherwise edited since then, except for the recent disasterous attempt...."



"it presently links to post# 9044. The correct link is to 90544, a typo. Would you insert the "5" in there for me, please, so it links to the right post?"