[nithin]

When execute long running queries the GUI is disabled (except the STOP icon to stop the execution) until the execution is finished, and can not do anything this time. This is because SQLyog doesn't make different connection to MySQL for each query tab (and for each query).

Currently this would be possible if open another instance of same connection (Duplicate connection..Ctrl+N) you will be able to switch between by using mouse or keyboard short-cut(Ctrl+tab). Additionally version 8.5 (its RC now) introduces tabbed interface for connections.

[nithin]

Quote:

the total length of the resulting schema tabs are much shorter if I use .sxml

From 8.5RC (we will release this by 2 days) onwards for SchemaDesigner & QuryBuilder tab header shows only the file name, not the extension. We believe this would solve the issue with long extension for those.

[nithin]

Drag-Drop files feature has been scheduled to version 8.51Beta. Expected release date of 1st beta is mid-June.

[nithin]

“It will always default to whatever the last saved connection you used.“

Yes, SQLyog behaves this way. Currently there's no command line option for this. Similar request is already present in our issue tracker, I will update it with this post. We will discuss about this request during the team meeting.

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

[nithin]

“This definitely should be a BUG request because the maximum digits that can be entered is 6 digits. “

This has been fixed and released 8.5 Beta1. Please verify this with your environment.

http://www.webyog.com/blog/2010/05/11/sqlyog-mysql-gui-8-5-beta-1-has-been-released/

[nithin]

Thanks for the info.

We will try this case to reproduce it.

btw: I have added this request to our issue tracker.

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

We will schedule it after we analyze it in detail.

[nithin]

Please create a support ticket from below link, we will continue there.

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

BTW: What type of connection used for source as well as target (Direct/HTTP/SSH)?

Is this error(Error No. 1046 No database selected) comes for a specific table or for all PK, Non PK tables?

[nithin]

Quote:

Would it be possible to bring up an alert when you attempt to close a query window with text in it?

Please make sure the option “Tools->Preferences->General->”Prompt if a tab with unsaved changes is closed” is selected. Please find the screen shot attached.

[nithin]

Ourselves we don't have any 4.x versions to verify this. But for us recent versions are much faster than v5.32. That could be a data specific issue or an issue with a specific datatype. So could you share the table?

Please create a support ticket from below link, there we can discuss about this issue in detail

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

[nithin]

Thanks for the response.

The reason to use extensions, .schemaxml & .queryxml are for better identification.

But you have a point: “the total length of the resulting schema tabs are much shorter if I use .sxml”

Let us discuss whether we can do anything for this.

[nithin]

Please create a support ticket from below link, and attach the dump there. If the dump is big we will give our 'yoursendit' credentials so you could attach the dump from there. (Also we may provide you some special binary to verify the problem)

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

Thank you

Nitin

[nithin]

Hello,

We have redesigned the File->Open menu with 8.4 version.

The release note(8.4beta2) tells:

The file menu has been reorganized to comply with standards. Note that to insert from a file into an open editor tab you must now use the context menu item from the editor. Such menu item in the context menu was also added with this release.

The logic is, while opening a file it checks for the extension, if the extension is neither .schemaxml or .queryxml It would open into the query tab. This has been introduced to avoid the complexities to use separate 'Open menu'/'recent files' for each query tab, schema designer and for query builder.

File->Open will detect the extension and open 'new' query/schema designer/query builder tab to load the file.

If need to open to same tab you could use context menu (menu right click editor/canvas)of the corresponding tab, But even here also if the extension is different it would open new tab to load this.

Is there any specific reason that you have changed the extension to .sxml ? Couldn't you make it as .schemaxml?

Thank you

Nithin

[nithin]

Hello,

Also Please verify few more things.

– In copy database dialog will you able to expand 'Views' folder?

– Execute this query against source database and tell the status:

show full tables from `database_name` where Table_type = 'view'

Regards

Nithin

[nithin]

Hello,

This is an issue with MySQL server.

Please refer this MySQL bug report, and let us know whether it has helped you or not.

MySQL bug report

Thanks

Nithin

[nithin]

Hello,

During the import process an error occured, it has been logged into the file “C:UserskevinAppDataRoamingSQLyogsqlyog.err”. SQLyog suggesting you to open this and see what error is logged into this file. Is this what you asked? If not please elaborate your question.

BTW: Have you solved issue with import process?, Have you tried what my collegue suggested you in the previous post?

“@ Error:Data truncated for column 'training' at row 1

I think the sql dump may contains sql_mode variable value as SQL_MODE ='STRICT_ALL_TABLES'.

please search it and set this value to ,

SET SQL_MODE='' in the SQL dump and try import.“

Thanks

Nithin

[Author]

Posts