rebuild all indexes on all qualifiers

Brian K. White brian at aljex.com
Fri Mar 4 00:32:55 PST 2005


----- Original Message ----- 
From: "Howie" <howiewz at beonthenet.com>
To: "filePro List" <filepro-list at seaslug.org>
Sent: Thursday, March 03, 2005 9:16 PM
Subject: rebuild all indexes on all qualifiers


> Does anyone know of a way to rebuild all the indexes on all the qualifiers
> on a file?
>
> I need to add a new index but there are 35 qualifiers and I would rather 
> not
> do them one at a time.
>
> Howie

I was going to post a simple loop but when I went looking for the script I'd 
made a long time ago (which must have been on some other box since I didn't 
find it) I instead found a nice reindex.dat on the system you are surely 
talking about, dated Nov '99 written by John E in '85 and then re-written by 
Bob S in 91. Obviously a saved email attachement since it's named .dat and 
not executable yet it's a shell script.

Looks good. Far more comprehensive than any off the cuff thing I was about 
to post, so, since it even has a nice dry-run test option, I say rename it 
to reindex, chmod 755, set TEST=T, and run it and see what commands it 
cranks out. If they look good then go for it. We have good backups :)

You might have to first run "global" to set pfdata & pfdir etc, and then 
unset pfqual, and then run reindex.

Since I don't know how that script got there (the datestamp is months before 
I started with the company so I know it wasn't me), and since the script 
doesn't specify in it's comments, I don't know how shareable it is so I 
can't post this cool thing I'm talking about for the rest of you. Pester 
John and Bob until one gives :)

and it's amazing how many server migrations have happened in just that time 
and that date stamp has been preserved the whole way... you'd think sooner 
or later it'd aquire the date of some restore or migration. I've done tape 
restores and rsyncs and plain old tars and all of those preserve time stamps 
by default so intellectually it shouldn't be amazing at all but to stand 
back and look at a dozen shufflings over 5 years and see that even such 
metadata is preserved, it somehow is anyway. Unix Rulz.

 Brian K. White  --  brian at aljex.com  --  http://www.aljex.com/bkw/
+++++[>+++[>+++++>+++++++<<-]<-]>>+.>.+++++.+++++++.-.[>+<---]>++.
filePro BBx  Linux SCO  Prosper/FACTS AutoCAD  #callahans Satriani



More information about the Filepro-list mailing list