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?