1 Topic by Reines (edited by Reines 2005-05-01 21:49)

  • Reines
  • Reines
  • Senior Member
  • Offline
  • Registered: 2004-10-07
  • Posts: 304

Topic: PunBB search tables pruning

Currently my MySql backup of my forums is ~200mb, and i am moving host. Im not sure what exactly the 3 seach tables (search_matches, search_cache and search_words) are used for, but they appear to be by far the biggest ones. Can i get away with emptying these 3 tables to make moving much easier? What would be the result of emptying them?

Thanks tongue

Reines's Website

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: PunBB search tables pruning

you can empty them then rebuild them with the maintenance part of the admin panel smile

FluxBB.
Connorhd.co.uk.

Connorhd's Website

  • Reines
  • Reines
  • Senior Member
  • Offline
  • Registered: 2004-10-07
  • Posts: 304

Re: PunBB search tables pruning

Ty smile So i can empty all 3 of them?

Reines's Website

  • Connorhd
  • Connorhd
  • Former PunBB Developer
  • Offline
  • From: Leeds, UK
  • Registered: 2004-06-13
  • Posts: 4,195

Re: PunBB search tables pruning

yeh search_cache is just recent searches i think not really sure, i'm pretty certain its ok to empty it though

FluxBB.
Connorhd.co.uk.

Connorhd's Website

  • Reines
  • Reines
  • Senior Member
  • Offline
  • Registered: 2004-10-07
  • Posts: 304

Re: PunBB search tables pruning

Thanks alot wink

Reines's Website