Re: ubh 3.x questions

--- In [email protected], Gerard Lanois <gerardlanois@y...> wrote:

> > o Is there an easy way (other than learning mysql commands) to clear 
> > out the downloaded headers?  In the above example, say I downloaded a 
> > million headers from a newsgroup from giganews but haven't used it in 
> > a while (dated) but don't need/want to download the latest
headers.  A 
> > million headers can tend to take up a LOT of disk space.  :-)

> Method #2 - use mysql commands
> 
> DELETE FROM assemble;
> DELETE FROM headers;
> DELETE FROM metainfo;
> DELETE FROM xref_headers;

I'm not sure this will free up space, try using
"TRUNCATE" instead of "DELETE FROM".
That will drop the table and recreate it.

-Sven



------------------------ Yahoo! Groups Sponsor ---------------------~-->
Buy Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark
Printer at MyInks.com.  Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/IHFolB/TM
---------------------------------------------------------------------~->

 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
     http://groups.yahoo.com/group/ubh/

<*> To unsubscribe from this group, send an email to:
     [email protected]

<*> Your use of Yahoo! Groups is subject to:
     http://docs.yahoo.com/info/terms/