Site is working again

Post by **_Christopher** » Mon Jun 09, 2008 11:40 pm

Pete,

Try here:

http://www.aletheia.proboards76.com/ind ... thread=278

I think that might be the same essay you're looking for, but I'm not positive. I'll know more once Josh answers my PM.

Post by **_thrombomodulin** » Tue Jun 10, 2008 6:22 am

Thanks Chris,

Christopher wrote: BTW, have you played around with phpBB at all? If so, what do you think of the suggestion I made about the guest accounts with the old userid's to replace the posts that are lost. I have a feeling they're still there, but without a proper reference to a user so they're just not returning in the query of the threads.

I am not familiar with phpBB. It is database driven, so the post I'm searching for could be a way of identifying whether the database still contains the missing posts. I would propose:

1. make an ascii dump of the entire database.
2. search text from this post in the ascii file.

If it is found, then we know the posts at least still exist. It would take investigation of the table structure to find out where the missing cross-references are at. The idea of the missing user might very well be right.

Pete

Post by **_darin-houston** » Tue Jun 10, 2008 8:13 am

thrombomodulin wrote:Thanks Chris,

Christopher wrote: I would propose:

1. make an ascii dump of the entire database.
2. search text from this post in the ascii file.

If it is found, then we know the posts at least still exist. It would take investigation of the table structure to find out where the missing cross-references are at. The idea of the missing user might very well be right.

Pete

In postgresql, I believe it's pgdump

pg_dump mydb > db.out

If you're on a *nix or mac, you can just pipe the output to grep to search for something like bshow1, which was uniquely in the missing posts.

pg_dump mydb | grep bshow1

(obviously, mydb is your database name).

Post by **_Suzana** » Tue Jun 10, 2008 8:55 am

Are you guys quite sure you are adhering to 1 Corinthians 14:27

Post by **_TK** » Tue Jun 10, 2008 9:08 am

I agree, suzana.

will an interpreter please step forward? if not, there must be silence.

TK

Post by **_TK** » Tue Jun 10, 2008 9:10 am

darin wrote:

obviously, mydb is your database name

Obviously! that's a good one, darin.

TK

Post by **_Paidion** » Tue Jun 10, 2008 10:55 am

In postlingua all-I-can-say.IS
pg_ina_poke|then dump_pg>buy.out
post grapple with_du boar & RUN

Post by **_TK** » Tue Jun 10, 2008 11:46 am

yes- and watch out for those tusks.

TK

Post by **_Christopher** » Tue Jun 10, 2008 11:57 am

Shandala - Shandala - SQL!

Post by **_TK** » Tue Jun 10, 2008 12:47 pm

hey christopher--

i have an interpretation- that's ancient babylonian for "nerds rule!"

all kidding aside, thank goodness for techies. i'm just jealous.

TK