[nithin]

Hello,

Please tell what type of connection you use: direct , remote or HTTP(If you use Enterprise version)?

MySQL server version?

Can you tell which version you were using before 8.18? And can you confirm you never faced this issue before?

And you no need to execute this query 'SET @@session.wait_timeout = 28800' manually. SQLyog provides this option while connecting. In Connection window you can see a group 'Session Idle timeout' and you can enter this 28800 to the textbox.

Thank you

Nithin

[nithin]

Hello,

We provide you a special community build where we tried to solve this issue.

http://www.webyog.com/downloads/betas/not_released/SQLyog821.2Community.exe

Can you check this with your environment and let's know the status?

Thank you

Nithin

[nithin]

Hello,

We are looking into this issue.

We may provide you a special build with the fix today before closing the office.

Thank you

Nithin

[nithin]

@TarkinInsideYou

That makes confusion. Better be single instance at a time.

[nithin]

Hello,

Thanks for using SQLyog.

Yes we moved the position of 'Trigger'(from 6.5 version).

This we done because Trigger is database object not Table object.

But I understand the difficulty if many triggers are present. We will consider to provide an option in preference that user can decide the position of Trigger whether it should be under Table or Database.

We will discuss this.

Thank you

Nithin

[nithin]

Hello,

We tried the case as you suggested(“subsequent click”) but not reproducible to us. I checked the code and found an issue at the same place where your crash dumps are pointing. So I fixed that and providing you a special binary. Can you download it and verify the fix with your environment and let's know the status?

http://webyog.com/downloads/betas/not_released/SQLyog821.1.exe

Thanks

Nithin

[nithin]

Hello,

Are you asking to retain the quires entered in editor when you open SQLyog next time?

Actually we had a discussion about this long back(and also retain the whole state of SQLyog when closed).

Right now priority is not set. We will discuss regarding this feature and prioritize accordingly.

Thanks

NIthin

[nithin]

Hello,

Team will discuss this point and update the status.

Regards

Nithin

[nithin]

Hello,

The request is already added in our issue tracker. We will consider this enhancement after 8.2 GA release.

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

Thanks

Nithin

[nithin]

Hello,

This issue has been fixed with 8.18 and released. Please download it and try.

Please see the release notes:

http://www.webyog.com/blog/2009/11/20/sqlyog-mysql-gui-8-18-and-8-2-rc2-has-been-released/

Thanks

Nithin

[nithin]

Hello ,

thanks for confirming the fix

Quote:

how you determine how many value sets can fit on a bulk insert statement

It depends on 'max_allowed_packet' or custom bulk size. Before adding each row values to INSERT we are checking whether it cross the 'max_allowed_packet' size or not. If it crosses we add this to new INSERT statement.

But at-least one value set will be in INSERT statement regardless of this checking.

The size of each row can find using the query..

SELECT LENGTH(`col_1`) + LENGTH(`col_2`) +…..+LENGTH(`col_n`) FROM table;

Instead of query in code we use corresponding MySQL API.

[nithin]

Hello,

There was an issue in calculating the size of INSERT. It was always not considering the length of 1st 'values set' in INSERT statements.

It has been fixed now in this special build. Now you should be able to EXPORT/IMPORT with 'Get Server Default' option checked in Preference. So the failed case must work for you now.

http://www.webyog.com/downloads/betas/not_…/SQLyog82.1.exe

Could you please verify the fix in your environment and let's know the status?

Thanks

Nithin

[nithin]

Hello,

We are analyzing this issue.

Quote:

it has been running for about 25 minutes with no errors and has passed the earlier point of failure.

You meant to say sql dump with Single Insert is imported fine for 25 mins and you stopped? But we cant tell the 'failure point' is already passed or not, it may fail in any point.

Please clarify this statement of your 1st post

Quote:

the insert statement that failed is 1091575 bytes long. the longest insert statement in the file is 1177199 bytes.

this size you mentioned is size of single INSERT statement(for single row) or BULK INSERT statement? And How did you get this?

And please do one more thing..We have an option to specify the BULK INSERT size in preference itself, give 500(K) in preference and do EXPORT(with BULK INSERT option checked) and Import the dump.

please see the screen shot how to set this option in preference.

[nithin]

Also please tell,

Have you experienced this freezing issue with any application other than SQLyog?

Regards

Nithin

[nithin]

Hello,

Thanks for your effort.

Quote:

Hi, I tried 8.16 with no significant changes in the connect dialog (attached image)

You mean still its freezing? (There was no change in connection dialog with 8.16, As I told there's some changes done for solving some OS compatibility issues)

Quote:

I believe it must have something to do with the password

typing in the password field leads to “Do you really want to delete the connection detail?” (attached image)

It seems to me that event handling is out of control.

The reason to 'ask you to delete connection details' may be you have pressed character 'D'. Please confirm you got 'D' character in your password? While typing password have you pressed Alt+D, or tab? Or when pressing 'D' the focus was there inside password edit box?

Why it happened is 'D' is keyboard shortcut assigned for 'Delete' button. Press 'Alt' and you could see an underscore(_) just below D of Delete button(_Delete), Its window's standard.

Quote:

there is no nt.dll on my system only ntdll.dll

Yes you are correct its ntdll.dll

Quote:

is there a way to be informed on replies by email, your post is 7 days old and I didn't checked the topic

You can create a ticket for privacy and for frequent notifications to your email :

http://www.webyog.com/support/ttx.cgi

Thanks

Nithin

[Author]

Posts