title: Sphinx search: getting rt indexing to work with mysql - first time
body: <p>I am trying to get rt indexing to work: 
  <a href="http://sphinxsearch.com/docs/current.html#rt-overview" rel="nofollow">http://sphinxsearch.com/docs/current.html#rt-overview</a></p>
  
  <p>I am missing the link between sphinx and mysql.</p>
  
  <p>In sphinx.conf I have:</p>
  
  <pre><code>index rt_test
  {
          type = rt
          path = /home/my/path/sphinx/data/rt_test
          rt_field = title
          rt_field = content
  }
  </code></pre>
  
  <p>I run /home/path/bin/indexer --all</p>
  
  <p>It tells me</p>
  
  <pre><code>skipping non-plain index 'rt_test'... (which I read is as it should be)
  </code></pre>
  
  <p>Then in mysql (logging in as I normally would):</p>
  
  <pre><code>create table rt_test(id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, title varchar(100),
  content varchar(100));
  
  insert into rt_test(title, content) values ("test title", "test content");
  
  SELECT * FROM rt_test WHERE MATCH('test');
  </code></pre>
  
  <p>This gives me a "wrong syntax" error. That's not surprising. Mysql just thinks that I
  have created a regular table and inserted regular data, and now it doesn't understand the
  Sphinx query.</p>
  
  <p>So what's the missing link? How does mysql know about sphinx? If I don't create the table first then I get an error that the table doesn't exist (sphinx has not made a "sphinx" table to be queried from mysql). </p>
  
  <p>I have installed sphinx on Linux as described here: 
  <a href="http://sphinxsearch.com/docs/current.html#installing" rel="nofollow">http://sphinxsearch.com/docs/current.html#installing</a> </p>
  
  <p>Using this version:</p>
  
  <p>wget <a href="http://sphinxsearch.com/files/sphinx-2.0.8-release.tar.gz" rel="nofollow">http://sphinxsearch.com/files/sphinx-2.0.8-release.tar.gz</a> </p>
  
  <p>Edit: I also ran $searchd</p>
  
  <pre><code>It says:
  
  WARNING: compat_sphinxql_magics=1 is deprecated; please update your applica
  WARNING: preopen_indexes=1 has no effect with seamless_rotate=0
  listening on all interfaces, port=9312
  listening on all interfaces, port=9306
  precaching index 'other'
  precaching index 'rt_test'
  precached 2 indexes in 0.012 sec
  </code></pre>