Sphinx related question

Question

How can I get all the records from the index using Sphinx? Just like a SELECT * FROM index ? I know that I can do something like this in order to get all the records matching a specific keyword: /usr/local/sphinx/bin/search keyword, but what I want to do is to get all the records from the index.

Answer 1

Try using an empty query. This worked for me with one of the releases.

Answer 2

You can do it by using an empty query or setting the matching mode to SPH_MATCH_FULLSCAN.

There isn't a way to do either of these things with the "search" command line utility but the test.py client that comes with the Sphinx source can be used for this:

python ./sphinx-0.9.9-rc2/api/test.py -h localhost -i myindex