[peterlaursen]

1) did you consider direct export to the MXL-based format of EXCEL 2003/2007. In case you use Excel 2000/2002 Microsoft download page has a 'compatibility pack' so that those old versions can read it.

2) If for some reason you want to use .csv .. well — best if you attached a small sample table dump so that we can se the problem!

In both cases: if there is a linebreak in the MySQL data there will also be in the exported file. That is basically the purpose of export: to create a copy in the new format as close to the original as possible!

However I think with the .csv-format you can 'search and replace' in and editor and replace the 'rn' sequence with a or t ( = 'tab') for instance to remove the linebreak.

Of course similar substitution is possible in the XML format as well.

Now — please attach:

* a small table dump

* a CSV exported from the table

* screen shot of you export settings

* screenshot of how you want data to be in Excel

[peterlaursen]

We have released 6.06 beta2. We believe this one fixes the issue with 'copy to other …' using two SSH connections. Please verify this.

The announcement:

http://www.webyog.com/forums//index.php?showtopic=3441

Your dump also tells us the position where the crash has occured with fast data entry as you dscribed it. It is clipboard related, as you suggested – that much we can confirm. But we still have not been able to reproduce a crash or find a bug in the code yet.

[peterlaursen]

Explained here:

http://webyog.com/faq/content/8/99/en/does…l-keywords.html

You turn it on/off in tools .. preferences

[peterlaursen]

Thanks.

We will check the dump file and discuss what else points you expressed here

But we cannot possibly relate to anything else that what exact information is written. We have 100.000's of user and can't know the skills of everyone.

[peterlaursen]

The crash is not reproducable (3 persons, 3 systems) on our side!

a DUMP file and/or a very detailed reproducable test case would be appreciated!

[peterlaursen]

fixed in development tree. It is the 'autocomplete' thread that crashes the program actually and will happen with single-char tablenames only.

[peterlaursen]

sorry .. I forgot this:

If you can reproduce a crash, please attach the DUMP file here

[peterlaursen]

An option to turn of DEFINER is a good idea when you are working with hosts when the same users do not exist!!

[peterlaursen]

I think the situation is one of those:

1) unstable connection or server

2) the max_allowed_packet setting in MySQL configuration is too low! Default is 1 M only and a single BLOB can be 64 M !

If you have acces to MySQL configuration then insert a line like this in the [mysqld] section of the configuration file (my.ini/my.cnf)

max_allowed_packet = 100M

The MySQL server must be restarted for the configuration change to take effect.

[peterlaursen]

We have not been able to do progress with the issues that you reported. We have had nothing to write about, and this is why we did not write. So simple, really.

We have however decided to 'push' reconnect in Structure Sync to the 6.1 tree.

Some more specific comments:

Quote:

Iinteractive mode does not appear to try to reconnect

.. well it does! But it does not seem to be able to! How can you be sure that the change is not with your connection or the server and network that you connect to? Can you clearly identify differences in the behaviour of recent SQLyog versions compared to older versions? If you have such information, provide it (also if you think you allready did). We cannot relate to information we do not have or did not understand!

Quote:

and it's never been this broken for me

But i understand that you feel that it is after release of version 6? Please be SPECIFIC!

Quote:

Customer service was already rude and offhand to a friend of mine, and I guess tech support is now equally dismissive

. Mostly looks like it is me, your are reffering to? i will not dicuss anonymous persons in a public Forum, but this person is very welcome to create a ticket and point our attention to not only technical matters, but also if he is dissatisfied with 'procedure', 'attitude' and 'tone'.

Quote:

SqlYog has a nasty habit of occasionally crashing out when doing interactive data entry …

We will (again) try to reproduce this tomorrow. Until now we have not been able to.

'

[peterlaursen]

“But the data pane scrollbar behaves funny.”

We know about such issues with 'funny' scrollbar behaviour. But I am not quite sure if this is a new 'materialisation'. I will ask a test engineer to record the details from this discussion and add to our task list.

We plan to solve all such issues in version 6.2 (my best guess: 2-3 months ahead)

[peterlaursen]

hmmm ..

first: we do not at all yet (though it is planned) support sorting from RESULT pane/tab. Do you mean DATA pane/tab?

second: as `intIpLookUpId`is the 1st column according to the CREATE TABLE definition

this

… ORDER BY `intIpLookUpId`;

and this

… ORDER BY 1;

is exactly the same! So I believe this is NOT the issue! (note it is 1 not '1' !)

Please give a detailed example of this “but the sort order did not display correctly”

1) a DUMP of a small test table (small means SMALL – no more than 15-20 rows and 4-6 columns!)

2) tell EXACTLY what/how you are doing! Clicking on the column header, or … ?

3) screendump of how it sorted

4) description of what you expected

BTW: don't use a beta version when a more recent stable one is available!

[peterlaursen]

Crash confirmed and reproduces on Vista, SQLyog 6.06 b2 (not_released) and MySQL 5.0.45.

The table`a`is created, but not `b`.

Our internal 6.1 development build does not crash here!

[peterlaursen]

I am sorry but I have to correct myself here. We have been researching and discussing this on Friday and there were something that I was not aware of.

SQLyog reconnects for every statement when connected with HTTP tunnel. The reason that we need this is that we support multiple queries returning multiple resultsets. Without reconnection we would only be able to retrieve one of the resultsets. As phpMyADmin does not support multiple resultsets it won't have to reconnect.

This reconnect is problematic with user variables, temporary tables and transactions.

Now as I wrote before persistent connections are pooled on the basis of ip, user etc. A new connection will (randomly) select one existing from the pool if it exists. If only one connection for each combination exists and is kept alive a new one will 'pick up' that one, if none such exists a new connection thread will be created . However there is no guarantee that the connection thread will not have been killed in between.

A practical experience is that persistent connection sometimes works and sometimes not with user variables, temporary tables and transactions. But this is NOT the purpose of persistent connections as defined by the PHP developer community. I cannot define the circumstances where it works and where it does not either!

Refer to: http://php.net/manual/en/features.persistent-connections.php

“People who aren't thoroughly familiar with the way web servers work and distribute the load may mistake persistent connects for what they're not. In particular, they do not give you an ability to open 'user sessions' on the same link, they do not give you an ability to build up a transaction efficiently, and they don't do a whole lot of other things. In fact, to be extremely clear about the subject, persistent connections don't give you any functionality that wasn't possible with their non-persistent brothers.”

and

“An important summary. Persistent connections were designed to have one-to-one mapping to regular connections. That means that you should always be able to replace persistent connections with non-persistent connections, and it won't change the way your script behaves. It may (and probably will) change the efficiency of the script, but not its behavior!”

I think we should discuss if we could possibly only reconnect when we need to in order to retrieve multiple results (that is I think for every SELECT and SHOW statement only).

[peterlaursen]

I am sorry but currently there is no such option.

The toolbar (icons), the menus and keyboard shortcuts are all hardcoded and compiled into the program.

[Author]

Posts