Sphinx search: getting rt indexing to work with mysql - first time -

i trying rt indexing work: http://sphinxsearch.com/docs/current.html#rt-overview

i missing link between sphinx , mysql.

in sphinx.conf have:

index rt_test {         type = rt         path = /home/my/path/sphinx/data/rt_test         rt_field = title         rt_field = content } 

i run /home/path/bin/indexer --all

it tells me

skipping non-plain index 'rt_test'... (which read should be) 

then in mysql (logging in would):

create table rt_test(id integer primary key not null auto_increment, title varchar(100), content varchar(100));  insert rt_test(title, content) values ("test title", "test content");  select * rt_test match('test'); 

this gives me "wrong syntax" error. that's not surprising. mysql thinks have created regular table , inserted regular data, , doesn't understand sphinx query.

so what's missing link? how mysql know sphinx? if don't create table first error table doesn't exist (sphinx has not made "sphinx" table queried mysql).

i have installed sphinx on linux described here: http://sphinxsearch.com/docs/current.html#installing

using version:

wget http://sphinxsearch.com/files/sphinx-2.0.8-release.tar.gz

edit: ran $searchd

it says:  warning: compat_sphinxql_magics=1 deprecated; please update applica warning: preopen_indexes=1 has no effect seamless_rotate=0 listening on interfaces, port=9312 listening on interfaces, port=9306 precaching index 'other' precaching index 'rt_test' precached 2 indexes in 0.012 sec 

i now.

i don't log regular mysql database, (funny enough) says:

$ mysql -h 127.0.0.1 -p 9306 

and don't create table. insert , search.

my regular database , sphinx mysql separate. have insert data regular database , sphinx database. search in sphinx database , use result full data in regular database.