CODEWITHSUNDEEP
sphinx
Daniel
Daniel

Reputation: 115

How do you get all records from Sphinx?

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.

Upvotes: 3

Views: 2079

Answers (3)

servermanfail
servermanfail

Reputation: 2538

In sphinx.conf, doctype has to be extern

Upvotes: 0

outcassed
outcassed

Reputation: 5273

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

Upvotes: 2

MattMcKnight
MattMcKnight

Reputation: 8290

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

Upvotes: 0

Related Questions