PDA

View Full Version : Is it safe to empty the "searchindex" table?

Chris M
10-13-2002, 02:11 PM
searchindex - 26,634 - 662.1 KB

Is it safe to empty it?:confused:

Satan
Steve Machol
10-13-2002, 03:07 PM
You can empty it, but then searches will not work on your forums.
Xenon
10-13-2002, 03:12 PM
so you have to reindex it afterwards ;)
Steve Machol
10-13-2002, 03:25 PM
But then what's the point of emptying it in the first place? Better to just leave it alone.
Xenon
10-13-2002, 03:30 PM
well whenever i want to download my DB i empty the searchindex before ;), less time needet

that's the point *gg*

also as you can read in the ACP: reindex searchindex: rarely needed, so why don't do it the complicated way by emptying the table via phpmyadmin first ;)

:)
Chris M
10-13-2002, 03:48 PM
How would I re-index it?:confused:

Satan
NTLDR
10-13-2002, 05:07 PM
On the upgrade counters page, at the bottom I think, there is a hyperlink to delete the search index and a forum button to re-index ;)
DrkFusion
10-13-2002, 05:25 PM
So what is the final verdict? lol We can or cannot?

-Arunan
Remi
10-13-2002, 05:25 PM
is it safe to reindex while the forum open!! , I don't want to close the forum for 24 hours :D

and kindly what is the query to see the most used words in your searchindex.


Thanks
Xenon
10-14-2002, 04:41 PM
Arunan: Yes you can, but normally there's no need to do it...

@Remi: normally you can do it on a running board, because it looks if a word already exists....
kix
01-13-2003, 08:18 AM
some forums+threads+users were removed from a fourm, and givin to me to start my own - This info is what i needed!! thank you - another question is (that might not belong here) the users avatars are missing along with blank info in the profile. I have exported/imported what i though were the correct database. Any know?