source blog
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass =
sql_db = myblog
sql_query = \
SELECT id, title, content, UNIX_TIMESTAMP(publish_date) \
AS publish_date, author_id FROM posts
sql_attr_uint = author_id
sql_attr_timestamp = publish_date
sql_query_info = SELECT id, title FROM posts WHERE ID=$id
}
index posts
{
source = blog
path = /usr/local/sphinx/var/data/blog
docinfo = extern
charset_type = sbcs
}
indexer
{
mem_limit = 32M
}

$ /usr/local/sphinx/bin/indexer --config /usr/local/sphinx/etc/sphinx-blog.conf --all

$ /usr/local/sphinx/bin/ search --config /usr/local/sphinx/etc/sphinx...