Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .