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