phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.

How to not save phpbb_search_wordlist anymore?


 
Search this topic... | Search General Support... | Search Box
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Author Message
Sylver Cheetah 53
Board Member



Joined: 17 Dec 2008

Posts: 426
Location: Milky Way


flag
PostPosted: Sat Dec 20, 2008 10:01 pm 
Post subject: How to not save phpbb_search_wordlist anymore?

I've noticed that half my databases are phpbb_search_wordlist, wich I understand is useless. icon_rolleyes.gif What can I do to not save this in future dumps? icon_confused.gif

Thanks!

_________________
Image link
My Forum || My Blog

phpBB2 forever! icon_smile.gif
Back to top
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 653
Location: Texas


flag
PostPosted: Sun Dec 21, 2008 12:00 am 
Post subject: Re: How to not save phpbb_search_wordlist anymore?

It's not useless, that table contains your search index. If you don't keep it as part of your backup, you won't have it as part of your restore. If you don't restore that table, nothing on your board will be searchable.

It is much faster to restore from a backup than to run one of the "search index rebuild" MODs for phpBB2. To run a restore takes minutes. To run a rebuild can take hours, depending on how many posts you have.

_________________
phpBBDoctor Blog
Back to top
Sylver Cheetah 53
Board Member



Joined: 17 Dec 2008

Posts: 426
Location: Milky Way


flag
PostPosted: Sun Dec 21, 2008 9:26 am 
Post subject: Re: How to not save phpbb_search_wordlist anymore?

Drathbun, thanks for clearing this out. icon_wink.gif Someone told me some while ago that they are not important, I can delete them. But if you say nothing will be searchebale, I guess I'll keep them. icon_lol.gif I thought that is stuff people search for... Well, you live and you learn. icon_biggrin.gif
_________________
Image link
My Forum || My Blog

phpBB2 forever! icon_smile.gif
Back to top
Citrix
Board Member



Joined: 19 Feb 2012

Posts: 42



PostPosted: Thu Feb 23, 2012 8:13 pm 
Post subject: Re: How to not save phpbb_search_wordlist anymore?

I truncate this table every day.
I added google search to find anything on the site. Is this not more efficient?
I didn't like the fact that table takes so much space.
Back to top
Display posts from previous:   
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0097 seconds using 15 queries. (SQL 0.0011 Parse 0.0002 Other 0.0084)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo