[ashwin]

Hi Mitch,

Quote:

I understand the “Limit rows” being disabled when the query has a LIMIT, but it doesn't make sense to me for the Refresh button to be disabled simply because of a LIMIT.

This will be fixed in SQLyog v10. Refresh button will not be disabled when there is a LIMIT in the query. I have added this in our issue-tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1759

We will update you once SQLyog v10 is released with this fix(probably in mid-March).

Thank you for your suggestion.

Regards,

Ashwin

[ashwin]

Hi,

F11 opens another Query tab with Table data in it if there is no query tab already opened in SQLyog.

Quote:

Another issue: If a table editor tab is open (which it will be if I haven't manually closed it), pressing F6 will focus it but not refresh it. Then I have to close it and reopen it to refresh the column data.

This is actually by design. Anyway, I have added this enhancement request in our Issue-tracker here: http://code.google.com/p/sqlyog/issues/detail?id=1758

Thank you for your suggestion.

Regards,

Ashwin A

[ashwin]

Hi,

Quote:

After I created a new table, I need to switch tables several times before it shows me the new table data.

Issue confirmed. We will include this fix n 9.6GA(probably this week-end or next week beginning)

Quote:

Also, where are all the keyboard shortcuts when creating a table? Like Alt+I to insert a new column.

We will add keyboard shortcuts to insert/delete/move-up/move-down as ALT+INSERT/ALT+DELETE/ALT+UP arrow/ALT+DOWN arrow respectively in 9.6GA.

Quote:

How do I get from the table editor to the Table Data view with keyboard shortcuts?

You can press F11 to open Table Data from anywhere in SQLyog.

Regards,

Ashwin A

[ashwin]

Quote:

I understand the “Limit rows” being disabled when the query has a LIMIT, but it doesn't make sense to me for the Refresh button to be disabled simply because of a LIMIT.

This is by design actually. But we will discuss in the next team meeting about 'enabling Refresh button when there is a LIMIT in the query' and update here.

[ashwin]

We are unable to reproduce this at our end. But, we came across this forum which you had posted two years back: http://www.webyog.com/forums/index.php?showtopic=5075

Quote:

what would cause the message to say unsuccessful if all tables were exported ok?

Does it happen always or very infrequently? Please answer Peter's questions(From the other forum post which you had created) here.

Quote:

There may still have been some error (a HTTP error or connection error for instance) after the last table was written to disk but before the connection was closed.

How frequently do you backup like this? Did you do after this particular job and if so, was there an error again or not?

If this error does not occur again it will be very hard to find the problem after more than a week.

[ashwin]

Hi,

Quote:

if you forget to type the password or type it incorrectly, the prompt hangs for around 50 seconds.

We are looking into this. We will get back to you.

Regards,

Ashwin A

[ashwin]

Hi,

Quote:

When you open Alter Table screen, if you only change the case of a column name, alter table will not detect a change nor try to update the table.

This issue has been fixed in 9.6 Beta2. Refer: http://www.webyog.com/blog/2012/02/02/sqlyog-mysql-gui-9-6-beta-2-released/ Anyway you can try the latest beta- http://www.webyog.com/blog/2012/02/08/sqlyog-mysql-gui-9-6-beta-3-released/ Stable build(9.6 GA) will be available in the next week.

Regards,

Ashwin A

[ashwin]

Thanks for the information.

Could you please answer to these also-

Quote:

Are you trying to import using 'Execute SQL script'? What error did you get when you tried to import? Please empty the SQLyog.err file and try restoring using 'Execute SQL script' and send us the file.

Also, tell your MySQL server version(SELECT VERSION()) where you are trying to import the SQL file(We can see from your dump that you used MySQL 5.1.53 server to backup the database).

And, connection type(Direct/SSH/HTTP) from where to took the SQL dump?

[ashwin]

Quote:

Is there an way to generat questions without database name's.

Hello,

We have released 9.6 Beta3 with this feature. “It is now optional if Query Builder will create statements with ‘fully qualified tablenames’ or not.” Refer: http://www.webyog.com/blog/2012/02/08/sqlyog-mysql-gui-9-6-beta-3-released/

Regards,

Ashwin A

[ashwin]

Quote:

But there seems to be some queries where the refresh button is enabled. See attached screen shot.

The Refresh button is enabled here because there is no LIMIT in the query. Also, in Preferences->Others->'Enable Autopaging in Result tab' should be enabled. When there is a LIMIT in the query then the Limit Rows and Refresh will be disabled.

[ashwin]

Hi,

We are checking this issue at our end. But we need the some more information-

Quote:

1) when i created the job everything seemed fine but i did not have a password for the hp user that was automatically put in there for me, and i got an error in saving the job. But when i looked at scheduled jobs it was there just fine.

What error are you getting on Saving the job? Are you getting 'Login failure: unknown user or password' error? Kindly attach the screenshot of the error message.

Quote:

2) it ran at the scheduled time, and in the log file it shows all the tables were exported successfully, but the final line below that was that the job did not run successfully.

Could you empty the log file and try to run the job file again and send us the log file?

Quote:

3) when i went to try to test the resulting sql file and import into an empty database, it failed.

Are you trying to import using 'Execute SQL script'? What error did you get when you tried to import? Please empty the SQLyog.err file and try restoring using 'Execute SQL script' and send us the file.

Also, tell your MySQL server version(SELECT VERSION()) where you are trying to import the SQL file(We can see from your dump that you used MySQL 5.1.53 server to backup the database).

Regards,

Ashwin A

[ashwin]

Quoting from your Ubuntu bug report-

Quote:

After a few hundred characters Xwindows will crash back to the login screen

We could reproduce this in any software which has a single-line edit control. For example, in Notepad File->Open, while typing a few hundred characters the program vanishes. This seems to be a Wine issue and definitely not a SQLyog issue.

[ashwin]

@JT Moree,

Please attach the crash dump here. You can find it in “/root/.wine/dosdevices/c:/users//Application Data/SQLyog/SQLyog_Dump_xxx.dmp”

[ashwin]

Hello,

We tried to reproduce this issue at our end, but we were unable to do it. After changing the SSH port, SQLyog could connect through the defined port successfully(Refer attached screen-shot). It could be a proxy/caching issue at your end. Could you post the sshd_config and ssh_config file here? If you don't want to post in public forums then you can create a support ticket by sending a mail to [email protected]. Also, please tell whether we could have a screen-sharing session using GoToMeeting to investigate the issue? Tell your timezone and preferred time for the meeting.

Regards,

Ashwin A

[ashwin]

Hi,

Quote:

SELECT * FROM table_name

LIMIT 11, 20;

With two arguments, the first argument specifies the offset of the first row to return, and the second specifies the maximum number of rows to return.

Refer: http://dev.mysql.com/doc/refman/5.1/en/select.html#id772444

In this case, 11 specifies the offset of the first row to return and 20 specifies the maximum number of rows to return. Hence SQLyog returns 20 rows when you execute this query.

If you want only 10 rows to be retrieved then you can execute:

SELECT * FROM table_name

LIMIT 11, 10;

Regards,

Ashwin A

[Author]

Posts