Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantPlease read:
http://webyog.com/faq/content/16/66/en/wha…-at-an-isp.html
My best idea is that you remove “https://”. As you use the COMMUNITY version you must connect directly. For direct connection to MySQL, protocol descriptors (like “https://” and “http://”) does not apply!
Some routing systems on some networks will simply ignore the protocol descriptor if the MySQL port is specified, but not all! And it is theoretically incorrect to specify like “https://” .. SQLyog is not a browser and MySQL is not a Webserver!
peterlaursen
ParticipantCould you please attache two structure-only dump to reproduce with?
That would thins a lot easier (and please zip!).
Create a ticket if you want privacy.
peterlaursen
ParticipantI replied in your ticket.
peterlaursen
ParticipantI do not think you told as clear before (in your ticket) as now that this happens when improting CSV files! it was not clear to me before that this was where to problem occurred. We will try to reproduce this on a 64 bit Windows tomorrow.
Except for that, are there other issues?
Now as you went to the Forums, I will close your ticket as it is preferable to communicate in one place only!
peterlaursen
ParticipantYou can start the program from command line of course. But SQLyog does not take parameters like connection names or connection strings. Also from inside the program there is no option to define a connection to connect automatically to predefined connections.
They have both been requested before. Refer to:
http://code.google.com/p/sqlyog/issues/detail?id=275
We are trying our best to 'catch up' with all those (small and medium) requests posted by users. We have done a lot with 7.0 release but not this!
peterlaursen
Participantconnections details are stored in the “sqlyog.ini” file. So if this file is recoverable, you can! Simply replace …
peterlaursen
ParticipantThere are 3 issues
1)
comments
// this is not a valid MySQL comment
— but this is
#and this is
/*and also this is*/
2)
you are missing a ';' to conclude IF .. ENDIF construction.
this
Code:BEGIN
IF ….
ENDIF
ENDshould be
Code:BEGIN
IF ….
ENDIF;
END3)
Since you (need to) use a ';' as delimiter inside the SP code you need to set a user defined DELIMITER around the SP code and conclude the SP with that. So the above becomes (using | as user DELIMITER)
Code:DELIMITER |
CREATE ….
BEGIN
IF ….
ENDIF;
END|In summary (without comments):
Code:delimiter |CREATE PROCEDURE `spLoadAddrType`
(IN param1 TINYINT(1), IN param2 VARCHAR(11), IN param3 TINYINT(1))
MODIFIES SQL DATA
SQL SECURITY Definer
COMMENT 'Loads addrtype via insert or update'
BEGIN
IF ((SELECT COUNT(*) FROM addrtype WHERE addrtypeid = param1)=0) THEN
INSERT INTO
addrtype(addrtypeid,
addrtypename,
dispord)
VALUES
(param1,
param2,
param3);
ELSE
UPDATE
addrtype
SET
addrtypename = param2,
dispord = param3
WHERE
addrtypeid = param1;
END IF;
END|Delimiter;
peterlaursen
ParticipantYou can try with version 7.0 TRIAL edition. Just install it to another folder then where your current version is.
If this is an issue with SQLyog that has been fixed between 6.16 and 7.0 there is really nothing more we can do.
peterlaursen
Participant1) please tell the program version! If not 7.0 then try it and see if problem is the same (there was some fix in reconnect recently)
2) is this happening with a specific server or more/all servers? What about a local server installed wiht default parameters?
3) how do you connect? direct, HTTP or SSH?
4) please tell the 'wait_timeout' and 'interactive_timeout' server settings (from SQLyog: tools .. show ..variables)
5) if this slowness also occuring for operations that does not involve server communication – like switching between TABS and operating menus in the interface?
peterlaursen
Participant1)
If data with special characters are stored with SQLyog does the problem persist? One reason for this could be that data are stored with UTF8 encoding into a (non-unicode) MySQL 3.23 table by some application. SQLyog does not encode/decode it displays data as they are stored. What application is writing and using those data?
2)
Please provide a small dump that illustrates this. A single table with a few rows of data is eonoug. Please dump with SQLyog – not any backup routine from a special application and not phpMyAdmin. Also attach a screenshot of how if displays for you in SQLyog, and in something else wehre it displays as you would expect. We will not be able to do progress without such *exact test case*.
peterlaursen
ParticipantAlso a small test case (a SQL dump of a database) could be usable for this discussion.
Just 4-5 tables with a few Foreign Keys/relationsships and a few rows of data in each table for instance.
peterlaursen
ParticipantI am moving this to 'customisation' where it belongs!
peterlaursen
Participant1)
“I'm blocked from doing anything in the application until the current query returns. Or am I simply missing something.”
Both yes and no! To run multiple queries simultaneously you nned to create two connections (this cannot possible be changed as this is how a MySQL server and client communicate). No matter how many query tabs you open in SQLyog, they will all use the same connection. To open another connection (using same connection details) use the menu .. file .. new connection using current settings (keyboard shotcut: Ctrl + N). To display all connection use menu .. windows .. cascade. QB must be opening a connection for every tab.
2)
“if I simultaneously run multiple queries (SHIFT-F9), the results are not returned for any of the queries until the last query has completed!
This is a very good point! I don't know if we ever thought about it like this! But it is correct! We will discuss this. Actually first result should ideally return at once and it should be possible to work in the RESULT TAB opened while the remaining queries are completing. This will require more 'multithreadedness' in SQLyog, but this is also planned!
We have considerations about about a 'revamp' of the GUI (such as a tabbed interface for connections). We have not decided on 'release strategy' in detail after 7.0 release. We have some details that were not completed in some features that I estimate would take around 2 months. After that discussion is open!
peterlaursen
ParticipantAdditional: the search function here uses MySQL full-text indexes. Most software like this does. Only strings >= 4 characters are indexed by MySQL full-text indexes.
peterlaursen
ParticipantOK .. thanks for your feedback. Anyway it should work with every MySQL version. As explained here:
http://webyog.com/faq/content/34/148/en/do…y-language.html
Quote:… The above applies to MySQL from version 4.1. Before that MySQL does not support SET NAMES. With MySQL 3.23 and 4.0 SQLyog will simply receive a 'binary copy' of what is stored on the server. The computer must be using a LOCALE setting matching the stream of data.Please try 6.56 or 7.0 RC2. If problems persist please reply back. We will check internally if there is some known bug in 6.51.
-
AuthorPosts