Example configuration for sphinx

sphinx.conf

source base 
{
  type = mysql
  sql_host = localhost
  sql_user = root
  sql_pass = root
  sql_db   = lookbooks_live
  sql_port = 3306
}

source min : base
{
  sql_query = select * from contacts
}

index idx_min
{
  path = idx
  source = min
}

searchd
{
  listen = 9313
  log = sphinx.log
  pid_file = sphinx.pid
}