SphinxQL support / custom startup commands on connect
| User, date | Message |
|---|---|
|
Written by kaseriisikas
1 year 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'; 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
1 year ago 3950 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 jfalch
1 year ago 222 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. |