[peterlaursen]

oh I see .. it was 'error 40' and not 'error 1064'

(an error 40 is an error that occurs 40 centimeters from the screen) 🙂

[peterlaursen]

Is it possible to use the ip of the proxy and not 'isa' ?

[peterlaursen]

Quote:

reports the following error message from all machines

all machines! Then it is very unlikely that it an issue on those client machines. Rather on the server side or on some transmission gear. Do you have an option to try another server. If not I could give you access to one.

You are PERFECTLY sure that the URL entered in SQLyog and the browser is the same?

[peterlaursen]

It is impossible to tell what the issue could be, with the information that you give here.

What is SQLyog program version?

From what MySQL version did you export and to which do you import?

With what program was the dump created?

Quote:

it says there was an error while excuting a query

An error 1064? If so it does not tell much!

Could you aswer the above questions and attach a small sample dump that fails to import?

[peterlaursen]

no way to do that with SJA. We do not plan to implement 'exchanging column data between corresponding rows' either.

What we are considering is a 'row based sync' where some rows can be sync in one direction and others in the other. But still complete rows will be transferred.

[peterlaursen]

I understand that you do not suggest tha SQLyog should parse for SQL-syntax itself. However if this (or similar)

Code:

Define filter as “where art = 2”
Select * from all_arts filter;

should be possible we would need to parse for our own language constructs. MySQL server does not understand this, so SQLyog would need to rewrite it before sending. That is possible in principle. We actually do something similar with the word DELIMITER (what is NOT a MySQL Keyword and the server does not understand the meaning of it. Support for that must be implemented in the client).

Another example is the SOURCE statement support by MySQL command line client. Actually this client parses for the occurence of this word as it is also not a SQL keyword/command and must be rewritten before sending to the server.

I think that with autocomplete and favorites we did a good part of the job. GUI query builder, 'smart filtering' from a cell context menu will be next step in this.

[peterlaursen]

@Mike .. Plase only ONE thread in the Forums per issue. It is easier to discuss if everything is the same place.

1) Of course SQLyog supports the “;” delimiter symbol. Also multiple statements delimited by “;” are supported. Please explain more in detail what porblems you experience!?

2) Your problem with user-variables (@….) most likely is that you are using a HTTP-connection. This is not a SQLyog issue but a limitation with the PHP mysql_connect() method. Refer to:

http://webyog.com/faq/21_103_en.html

You can try to replace mysql_connect() with mysql_pconnect() as described in this FAQ:

http://webyog.com/faq/21_103_en.html.

Maybe it works – maybe not. It depends on the server configuration. Not only PHP but also Webserver must be configured to allow for in. In PHP the php.ini must have the line “persistent = on”

Also note that SQLyog reconnect autmatically if connection is lost. User-variables are connection-specific so after reconnect the user-variables of previous connection are gone.

[peterlaursen]

Quote:

At the moment it is only possible to export whole tables as CSV data

NO – not correct!

You can export from the RESULT tab as well. The query generating the result can have a WHERE-clause.

Please understand that (except for parsing for DELIMITERS (the “;” character and the “DELIMITER” string)), there is no parsing of the SQL language that are done in SQLyog. That is how database CLIENTS generally are: they interface to the functionalities of the SERVER. It is the server that parses, executes, converts character sets etc. etc. – not SQLyog.

You can save frequently used strings such as WHERE-clauses in 'favorites'

[peterlaursen]

the FREE version does not support HTTP-tunnelling. You will need the ENTERPRISE version for that. There is a free 1-month TRIAL available. Note that FREE and Enterprise TRIAL are two different binaries.

http://webyog.com/en/sqlyog_feature_matrix.php

http://webyog.com/faq/33_137_en.html

[peterlaursen]

Please tell EXACTLY what program version you used. Program help .. about tells.

Your points:

* crahses: code has been completely rewritten in the 5.2 tree and that introduced some crashing bugs that how been fixed.

* slow slider: Are you talking about the DATA tab or the RESULT tab? How many rows are the database or the resultset

* we believe the user inferface is the most intuitive that exists in the MySQL world. What database programs were you referring to?

* your last point: thanks for the info. I am not sure how I should use it?

[peterlaursen]

I shall not tell what happened. it need not be the MySQL server. Could be a trivial harware issue (cable, router, switch , transmitter) as well.

If you are in control of the server you can enable the 'general log' by inserting something like

log = mylog.log

in the [mysqld] section of the my.ini/my.cnf file and you can see how often it reconnects.

[peterlaursen]

Quote:

I tried to open with sqlyog and in the query window, I just see tables? How do I view all?

I am sorry, but I do not understand the problem. What had you expected to see? If you select a table in the Object Browser (the left column of the program) and click the DATA tab it will show you data. If you check the 'select all' box, all data will be loaded and shown.

[peterlaursen]

Try issuing the “SHOW DATABASES” command manually from SQLyog SQL-pane, and some webbased client like phpMyAdmin. Does that return something?

“My sysadmin says ….” hmmm. They always try to reject the idea that they have a problem in the first place. 🙁

[peterlaursen]

This is because of a dynamic extension for PHP that is not configured.

You cannot do anything about it. Only the Sysadmin can. Are you in control of the server youself, or is it a shared server at an ISP?

Please also inform about the PHP version.

You can create and upload a .php file reading like:

and the phpinfo() function will give all details about PHP configuration

[peterlaursen]

@Santosh

Please only create ONE discusion/thread per issue. It makes things easier to handle if all relevant information is in one place.

[Author]

Posts