We can get all the details about the sphinxs from its online documentation including information on installing sphinxs on windows. But a little more descriptive installation process will make it easier to install and use. Below is the step wise description to install sphinxs.
Extract content of the package to a folder say “sphinx” folder in c: i.e. c:\sphinx.
Open the command prompt and get into c:\sphinx\bin directory
Execute the command searchd –install –config C:\Sphinx\sphinx.conf.in –servicename SphinxSearch
With the above step we are done with the sphinx installation. Now lets configure it so it will respond to our queries.
Create a db named test.
Import the example.sql(which is there with the package) to the test db.
Now open sphinx.conf.in and set the following params according to our db config
sql_host = localhost
sql_user = test
sql_db = test
sql_port = 3306 # optional, default is 3306
Create a folder index to store the indexes and other dynamically generated file by sphinxs lets say c:\sphinx\index\
Now replace all the @CONFDIR@/log/ and @CONFDIR@/data/ with the path of the folder we have created i.e. c:\sphinx\index\ here.
@CONFDIR@/log/searchd.log will be replaced by C:\sphinx\index\searchd.log
@CONFDIR@/data/rt will be replace byC:\sphinx\index\rt
Now we should run the indexer by the following command so that sphinxs will index out the data in the db. indexer -c c:\sphinx\sphinx.conf.in –all
Now we can check the search engine by the following command search -c c:\sphinx\sphinx.conf.in test (here test is string to be searched in the index)We can see that search will list out the results on the command prompt. Now using some server side scripting like php we can interact with the sphinxs search engine get our searching problem solved neither overloading the db nor paying the cost of loosing transaction facility.
This a just a brief description about the sphinxs installation and configuration . But a lot more are there . For more refer online documentation