distal-attribute
distal-attribute
distal-attribute
distal-attribute

SphinxQL support / custom startup commands on connect

User, date Message
Written by kaseriisikas
2 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

SHOW STATUS LIKE 'Uptime';
SHOW DATABASES;
...


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
2 years ago
4801 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
2 years ago
354 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.