[peterlaursen]

As I wrote I'll need developers to answer in technical terms how SQLyog 'finds out' that a connections is established. Probably we will need some kind of debug build or remote access.

But if this was a general issue we would have heard about it long time ago. An we are not that silly (I hope not).

[peterlaursen]

Your are completely right in my opinion. Several implemetations are possible.

[peterlaursen]

I can add that I repeated the query to the webyog.com server while downloading 5 CD-ISO's. Due the bandwidth limitation the query now took more than 2 hours to complete. No such timeout!

There must be some specific reason for this on you network. Saying so I do not say that there is not something that can be improved or optimized. But we will need to know that specific reason then! At least I agree that the error message could be better in this situation!

And actually I do not think it is true that the query takes that long. It is the transfer of data over the HTTP-tunnel that does. At least with what I did. How the data (and what data) are buffered I really do not know!

[peterlaursen]

Also: you do not have a proxy that 'cuts' after 30 seconds?

[peterlaursen]

OK .. I think I understand now.

You experience this when running a single query lasting more than 30 seconds to complete.

Well .. then I agree that mysql_connect and mysql_pconnect should not make any difference!

I cannot reproduce. I just executed a query like 'Select * from …' taking more than 15 minutes to complete on the server at webyog.com and another similar on my local WAMP stack lasting about 6 minutes. They both returned what they should and I did not have such message.

Quote:

To me it seems like SQLYog doesn't even know that it connected in the first place.

Maybe so! But it is not a general problems then! I will have to call in developers to tell HOW SQLyog decides that a connection is established with HTTP tunnel!

If you have an option to connect directly or with SSH it would be nice to know if it is the same problem!

Quote:

connect has no time limits associated with it

There is no PHP config setting that you overlooked ?

What is the SQLyog program version?

[peterlaursen]

I am sorry, but I am not sure that I understand. Could you explain more in details? example? Screenshot?

With SQLyog 5.1x the .sql file is encoded using UTF8 on MySQL versions that support that. That is 4.1 and greater. A .sql file that is UTF8-encoded and has accented charracters cannot be read correctly with MySQL 4.0 and lower.

Is this the issue? What are the MySQL versions involved?

The backup 'powertool' of SQLyog ENTERPRISE has an option to deselect UTF8 encoding – also when exporting from MySQL 4.1 and higher.

[peterlaursen]

Now you can easy create a .bat file reading like

Code:

sja backupjob_1.xml
sja backupjob_2.xml
…
sja backupjob_n.xml

and schedule that .bat file. It also is very easy to use a text editor to 'search and replace' and thus create the various job files once you got one to use as a 'template'.

However I think that databases of different use and importance should have different 'backup strategy' ? You can then group them into different categories and create a .bat file for each group.

Related FAQ's:

http://webyog.com/faq/24_121_en.html

http://webyog.com/faq/27_35_en.html

[peterlaursen]

I am not sure I understand!

First an EXACT 'create statement' would always make things easier! It is not clear what data types you use – and therefor not what is the correct sorting order either. Your dataes look weird with DD-MM-YYY (or MM-DD-YYYY ?) and not YYYY-MM-DD as would be normal with MySQl

I would propose simply (provided that I understand):

Code:

select MAGASIN,ARTICLE_NT, DATE_TARIF, marge_theo FROM tar order by marge_theo desc limit 1;

But do you want to retrieve the max. value for date_tarif and at the same time the max. value for marge_theo (not corresponding values)?

Please:

1) the 'create statement for the table' (or better a complete dump with structure + data)

2) what exactly should be returned?

[peterlaursen]

I am not sure I understand this.

Are you sure that it is SQLyog that initiates this disconnect?

To me it looks like it must a settting at your ISP that does that?

First try to edit the tunnelling file and replace the mysql_connct() with mysql_pconnect() connection method.

http://webyog.com/faq/21_103_en.html (paragraph 3)

[peterlaursen]

OK here they go!

😀 🙂 😀 🙂 😀 🙂 😀 🙂

[peterlaursen]

We absolutely do intend to build SQLyog very soon compiled with UNICODE. That will be first step in the 5.2 tree.

I am sorry if you got another impression. But I think we have been very clear on how the program handles unicode data.

[peterlaursen]

First of all please try a more recent SQLyog version.

We are practically helpless it we do not have a similar source databae and the ODBC driver.

Do you know if there is some DEMO/TRIAL available ?

[peterlaursen]

What is the program version that you are using?

What is the Source database that you are importing from?

What is the MySQL version that you are importing to?

Is it possible to create a not too big and unambigious 'test case' ? With this error we will only need structure – no data I think? Also try saving the jobfile and attach it here (or create a ticket if you don't want to expose it)

This “”ERROR: 1280, Incorrect index name”” is a MySQL server error – not a SQLyog error. It looks like index names are generated from the column names – and that these column names are not valid with MySQL as index names. Some PK-column for each table? If so try changing the column name from the 'map' button – and avoid using special characters.

[peterlaursen]

Please answer (both of you):

1: It you let it finish how much memory does SQLyog use?

2: Does SQLyog use all available CPU while the data are loading?

In this situation I do not think it is a SQLyog issue! It is the time it takes for the server to send the data and to have it transferred.

However it IS a problem that SQLyog stores all rows of data in this situation and not just a 'window to the data'. A 'fix' (or whatever you may call it) is not round the corner. Not that it is unimportant, but ther are other issues that are not either!

[peterlaursen]

Code:

of course I have selected utf8

But that is what is wrong!! Choose 'latin1' or 'big5' or whatever language you want to work with!

The limitation is that you can only work with non-ascii characters from one language at a time!

[Author]

Posts