Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to test out a Sphinx cookbook, but I need a database to do so.

I have created the database locally, but I need to know where the default path is for the index of the table I created.

This is the error I am currently getting when trying to run sphinx because the path to the index is wrong:

WARNING: index 'phoneindex': preload: failed to open /var/lib/mysql/mysql.sph: No such       file or directory; NOT SERVING
FATAL: no valid indexes to serve

Where can I find mysql.sph? Or how/when is that file created?


share|improve this question
Is your question about MySQL MyISAM index files located in /var/lib/mysql/databasename/tablename.MYI or Sphinx index files? – gertvdijk Sep 18 '12 at 21:47
Actually, I guess it is the Sphinx index files... Do i create them? – Marcus Morris Sep 18 '12 at 21:58
ok, I got it to work. I had to index it first using sudo indexer -c /etc/sphinxsearch/sphinx.conf phoneindex. Thanks for pointing out what I should actually be looking for! – Marcus Morris Sep 18 '12 at 22:25

You're confusing some things:

An indexer READS your MySQL data through a connection on the MySQL service, not by reading the MySQL files.

Your index would be in the Sphinx data repository set in the Sphinx conf for each index with a path parameter.

index myindex{
source = ...
path = /path/to/your/sphinx/data
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.