I tried to delete some URLs which should not be indexed: $ ./index -C -u http://vs1.rz.uni-osnabrueck.de/video/% ...(many Delete ...) Delete url: http://vs1.rz.uni-osnabrueck.de/video/ub/work/Info_Clips/QuickTime4_Required.mov Saving real-time database ... done. Saving delta files [..................................................] done. Saving real-time ... done Saving redirects ... done Splitting href delta file ... done Saving href delta files ... done Saving direct href delta files ... done Calculating ranks [................................................] done. Saving lastmods ... done Generating word site .Unsupported protocol in /users/physik/theo3/severien/abstract.html:/// .. done Deleted 44198 urls ---
OK, this number (44198) seems to be alright. But mysql monitor shows: mysql> select sites.site, count(url) as 'Anzahl' from urlword,sites where url like 'http://vs1%/video/%' and status=200 and sites.site_id=urlword.site_id group by urlword.site_id order by sites.site; +----------------------------------+--------+ | site | Anzahl | +----------------------------------+--------+ | http://vs1.rz.uni-osnabrueck.de/ | 43534 | +----------------------------------+--------+ 1 row in set (1.40 sec) This number should be zero, as everything in /video/ was deleted. (I checked with: select url from urlword where status=200 and url like 'http://vs1.%/video/%'; and got many results, too.) How can I really delete these URLs? What command is necessary to update the urlword table in the aspseek12 database.? Thanks for comments. Yours Frank #-------------------------------------------------------# Dipl.-Math. Frank Elsner Universitaet Osnabrueck (University of Osnabrueck) - Rechenzentrum - (Computing Center) Albrechstrasse 28, AVZ D-49076 Osnabrueck Deutschland (Germany) Tel. (Phone): ++49 (0)541/969-2343 Fax: -2470 E-Mail: [EMAIL PROTECTED] #-------------------------------------------------------#
