[peterlaursen]

We can simulate/reproduce the situation if we start a long running query and disconnect the network cable before result has returned.

It looks like a problem with the MySQL API on Vista in combination with a lost connection (possibly due to hardware error).

We will research into it to find more detailed information if we can!

[peterlaursen]

there are no plans to schedule 'copy database'

If database_X8 is static (and if YOU know the structure of it)

this “copy database_X8 (old structure) from server_X8 to database_K2_raw (old structure)”

.. could be done by a 'notifications service' job executing CREATE DATABASE and CREATE TABLE statements.

Also you should try if the CONCAT_WS error still occurs. With recent versions we handle most differences between server versions.

[peterlaursen]

I think you have upgraded SQLyog …

As we support more export options/formats a new dialogue will open. Here just select the CSV option.

Did I miss something?

[peterlaursen]

No other networking programs having problems?

What about MySQL Administrator, Query Browser?

It is a new PC. There might be hardware issues

This is NOT related to the crash at startup and we have no other such reports.

[peterlaursen]

this

http://code.google.com/p/sqlyog/issues/detail?id=208

.. might be related!

[peterlaursen]

1)

“I only have a “MySQL” tab” .. OK .. you are using the COMMUNITY version!

2)

All this “My task manager does not show the app as “not responding” until I start trying to click around in the SQLYog app. If I hit the “X”, or “File > Exit”, I get the dialog box saying “Could not close connection. Query(s) are being executed.” Hitting OK brings me back to the app, which now has a status bar that changed to “Ready”. However, the query has not returned a result, and I still have the “hour glass” cursor when hovering over the app (Vista's default is a spinny-circle icon). Task manager still says the app is “running”. After clicking on various spots, going through the menus (most of which are greyed out in this state), the task manager and app now finally say “Not Responding”.”

I think I a few times have expericed something similar if connection broke while a query is running. It will not then retrieve results (of course), but SQLyog does not seem to 'be told' by the OS that connection is broken either. I will try to work with our test engineers on Monday to see if we can reproduce it consistently.

3)

Do you have any firewalls enabled (including the one shipped with Vista) ?

[peterlaursen]

Did you read this

http://www.webyog.com/faq/content/23/18/en…on-denied-.html

This error is an authentication error – not a connection error. That means that you are in contact with the server (the server sends the error mesage).

You are sure you did not specify a password when you installed the server?

[peterlaursen]

'hanging' is another issue than 'crashing', I think.

Is it a remote or local server ?

How do you connect (direct, HTTP, SSH) ?

Can you absolutely positively that this does not happen with another SQLyog version/and Operating System when connecting to the same server with the same parameters ?

We have several DELL systems ourselves, but we purchase without any OS and preinstalled software. Currently i am wirting form A HP laptop (dv9000 sries) with preinstalled Vista and some softwares.

If you can allow us to connect to the server, you can crate a ticket with connection details. Ideally do like this: Create a new empty database and a new user (for us). GRANT that user all privileges to that databse only. Then we will not be able to access your data .. what we basically do not want either!

[peterlaursen]

Do you suggest it should function identically to F5 or slightly different in some way?

From menu .. about .. keyboard shortcuts you can see what is available now (if you did not know!)

[peterlaursen]

I have allready added your request here:

http://code.google.com/p/sqlyog/issues/det…5&start=100

We will put all efforts into releasing 6.1 now.

Exact priorities for 6.2 and later will be decided only as 6.1 gets close to FINAL release.

[peterlaursen]

It is the letter 'í' in 'C:Documents and SettingsondraData aplikací' that causes the problem.

It will also fail with username 'jörn', 'andrè' etc.

ASCII/UTF8 mismatch with accented characters in file path!

Not enough time today to verify the fix, but 99% that we got it fixed in the code!

[peterlaursen]

did you read http://webyog.com/faq/content/23/18/en/err…on-denied-.html

.. as well as other FAQs in same category and the 'getting started' paragraph in help file.

1) the http-issue

This is an authencation error, not a connection error

> try 'localhost' or '127.0.0.1' as 'MySQL host'. With HTTP tunnel you connect to MySQL from webserver/PHP on the remote host/network, not from your local machine. Probably this user does has not been allowed remote connections. (when specifying a global ip/alias it may not be 'resolved' to 'localhost')

2) the ssh-issue

this is a connection error!

–>try only 'mydomainwashere.com' not 'ssh://mydomainwashere.com'.

–>the user and password to specify on the 'SSH' tab is SSH/OS user – not MySQL user!

–>also here try use 'localhost' as host on the MySQL tab (note this was edited!)

[peterlaursen]

additional: Whether MONyog 32bit will run with a 64 bit Linux depends on the distribution and whether 32 bit libraries are available.

[peterlaursen]

OK .. thanks got it.

But what you are saying is that the file gets copied. But it is ignored/not used.

Please confirm (and my apology for slow understanding if it is the case!)

[peterlaursen]

@eclairdev

Would you mind creating a ticket and attach your sqlyog.ini? (please zip).

Maybe some silly issue with the content of the file!

[Author]

Posts