Re: Re: ubh 3.x questions

--- [email protected] wrote:
> --- 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.

You don't want to do that.  Read the documentation for the TRUNCATE
command.  Specifically, this:

"The table handler might not remember the last used AUTO_INCREMENT 
value but may start counting from the beginning."


Use DELETE.  It is safer.

-Gerard



------------------------ 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/