SphinxQL support / custom startup commands on connect

User, date Message
Written by kaseriisikas
3 years ago
Category: Feature discussion
1 posts since Wed, 30 Nov 11
I've been using HeidiSQL for several months and I really like this tool. Keep up the good work!

I'd like to use HeidiSQL to make fulltext queries on a Sphinx Search Server (http://www.sphinxsearch.com), which has a MySQL-like interface (http://sphinxsearch.com/docs/2.0.2/sphinxql-reference.html).
I can make a connection and run queries, but some errors pop out in the process. Specifically, the SphinxQL does not seem to support the queries


that are being executed after establishing the connection. Sphinx cannot be blamed, since it is not a true MySQL server and probably will never support these.

However, is it possible to define a new session (in the Session manager) in a way that no additional startup commands (even those required to fetch a list of databases) are sent to server? Or perhaps override the default startup commands from a file? I've tried the "Startup script" parameter in the Session manager, but that does not work the way I'd like.
Written by ansgar
3 years ago
5012 posts since Fri, 07 Apr 06
Well Heidi is a MySQL + MSSQL client, and does not support Sphinx. I wonder you can connect to it at all with Heidi.
Written by jfalchMoney, Euro
3 years ago
400 posts since Sat, 17 Oct 09
MariaDB has Sphinx access as a "storage engine" plugin (http://kb.askmonty.org/en/about-sphinxse/2941/); this way, you define "sphinx databases" within your mysql server (which do access an external sphinx server). This way, no automatic server startup code should be run for a sphinx database. I do not know wether this plugin will run with your server, but it should be worth a try.

Please login to leave a reply, or register at first.