PHPBB2: Rebuild Search Index?

[pi0tr3k]

Hi all,

I need to rebuild my search index on platinumw, because of the DB switch from myisam => innodb.
A lot of lost data ( from tables search_wordlist and search_wordmatch )..

I've been looking around and found this mod:
http://www.phpbbhacks.com/download/434

Info:

This hack adds a new feature to the Admin Panel. It rebuilds the two tables search_wordlist and search_wordmatch. These tables are used for the search function.

So yeah, a bot is sent on your forums to each category, search for words or w.e, and put them in the tables.

Before the DB switch, I had 5 million words in search_wordmatch.. now only few K.

The mod is working, but VERY VERY SLOW.
In few hours (4-5) only 13K topics were indexed. And then I had to close my PC so it stopped.

My question is now:
- is it possible to rebuild your search via sql and not via this mod?
- are there any other ways to rebuild your search (and fast methods)

Please, help me asap

Cheers, pi0

pi0tr3k Reviewed by pi0tr3k on 2nd Jan 2010. PHPBB2: Rebuild Search Index? Hi all, I need to rebuild my search index on platinumw, because of the DB switch from myisam => innodb. A lot of lost data ( from tables search_wordlist and search_wordmatch ).. I've been looking around and found this mod: http://www.phpbbhacks.com/download/434 Info: Rating: 5