Online demo Privacy policy

Recreate sphinx data


This is a troubleshooting task, use it only when you have to or you are advised to rebuild the sphinx index from scratch.

Piler relies heavily on the sphinx index data. The reindex utility is for healing it if anything goes wrong.

The reindex utility reads data from the metadata table, then retrieves the files from the /var/piler/store directory. Then it parses them again, and puts data to be indexed to the sph_index table, so the sphinx indexer utility can reindex these messages.


reindex -f <from id> -t <to id> -a [-p]

-f: start from index

-t: end with index

-a: reindex all records

-p: display processed/all records counters

So the following command will get all messages with metadata table id between 1 and 1000.

reindex -f 1 -t 1000

Reindex all records:

reindex -a

If you need to reindex lots of email then I recommend you to disable the cron entries for the indexer process and run the following commands manually:


When you are done enable the cron entries again.

Before running reindex, please change to a directory where the piler user has read and write permissions.

Google Analytics Alternative