[ashwin]

Hello,

Quote:

I'm certain that SQLyog used to show the number of rows returned from a query and an indication of the elapsed time for the query in the status bar at the bottom of the window when looking at the “Result” tab. I found that very useful and referred to it frequently. With this version that information is no longer present.

We have released SQLyog 9.31 with this bug fix.

Please refer to:

http://www.webyog.com/blog/2011/11/07/sqlyog-mysql-gui-9-31-released/

Regards,

Ashwin A

[ashwin]

Hi Pieter,

Quote:

I am new to websql client and was wondering if it has the ability to reverse engineer a database schema from MySQL?

Unfortunately reverse engineering is not possible.

You may save a Query Builder session and open it later. But the format used for saving is SQLyog's own/private XML-based format and not SQL. And same applies for the Schema Designer.

Should we support opening a SQL statement in SQLyog Query Builder it would require a SQL-parser inside SQLyog. The parser that is part of the server cannot be accessed directly (only by executing a statement the parser code will execute). Also for legal/license reasons we also cannot copy and link the the parser code from the server into SQLyog even if we wanted to. It would also be very difficult to handle some subtle differences in some respects between different MySQL versions (for instance 'serialized joins' behave a little different in some cases with different MySQL versions depending on the syntax used).

In MySQL *SQL parsing* is (and has to be done) server-side. And therefore, it is not a job for the client.

Thanks for using SQLyog.

Regards,

Ashwin A

[ashwin]

Issue is confirmed. This will be fixed in the next public release. Thanks for reporting this issue to us.

Regards,

Ashwin A

[ashwin]

Quote:

But, the Duplicate row might have been an improvement, except it appears to have a bug. After you duplicate a line, then any changes you make to either line, are applied to both of them. What the heck is the point of that ??? You have different lines to have different information, not two lines that are for ever the same. Then it gets worse, you realise you are stuck with two lines, so you go to delete one. But no, the only option is to delete both, so you lose the duplicated line, plus your original real data. Major flaw sorry guys.

Please read: http://www.webyog.com/faq/content/28/70/en/i-only-changed-one-row-of-data-but-sqlyog-wants-to-update-more-rows-in-the-database-why.html

Are you sure that you have defined a Primary Key on the table?

Quote:

I find the editing very painful as well. Which is a shame as there are many good features. But after many years of using phpmyadmin, the ease with which you can search for data, edit data, insert lines is far better than this program.

The customer filter is ok, but still way too much work just to search in a field/s. This is a database after all, and this is what you need to do.

Have you tried Data Search as introduced in 9.1 and refined in 9.2?

Please refer

http://www.webyog.com/blog/2011/06/09/mysql-data-search-data-at-your-finger-tips/

http://www.webyog.com/blog/2011/07/25/data-search-enhanced-in-sqlyog-9-2/

… as well as the paragraph on Data Search in the program help file (help .. help menu) of 9.2.

Regards,

Ashwin A

[ashwin]

Issue is confirmed. Under wine status bar does not show any messages in SQLyog v9.30. This will be fixed in the next public release. Thanks for reporting this issue to us.

Regards,

Ashwin A

[ashwin]

Hi Andy Wong,

Quote:

I searched this forum and found a similar problem with a previous version but we're using the latest 9.30 which is supposed to be fixed.

Please read 8.62 release notes:

http://www.webyog.com/blog/2010/10/08/sqlyog-mysql-gui-8-62-released/

“* SJA now supports an additional -r parameter that tells how big CHUNKS should be when copying to an empty table. The -r parameter has only effect with Data Sync jobs and is ignored with other types of jobs. This is a command line option only that is not supported from the GUI Wizard.”

Also read FAQ: http://webyog.com/faq/content/27/114/en/introduction-to-the-_sqlyog-job-agent_-sja.html

Quote from the FAQ: “Data sync jobs additionally supports a '-r' parameter (it is ignored with other types of jobs). It has only an effect when a non-empty source-table is synced to an empty target-table and defines how big CHUNKS should be fetched from source server (for a (source) HTTP connection it is 1000 rows by default if -r option is not specified explicitly). -r”2000” will copy CHUNKS of 2000 rows from source. If no -r parameter is specified SQLyog will fetch “all rows” from source server in one 'SELECT' query operation what may cause memory exhaustion on the client machine.”

Please tell if you understand how to use this information or if you need more help.

Regards,

Ashwin A

[ashwin]

Just copy/backup the SQLyog.ini file and paste in AppData folder (same path) of another system where there is SQLyog.

Exact file path is:

For Windows XP/2003:

C:documents and settingsuserapplication dataSQLyogsqlyog.ini

For Windows Vista/2008/Win7:

C:UsersuserAppDataRoamingSQLyogsqlyog.ini

Please note that the 'AppData' folder is a hidden folder. You need to unhide it from Control Panel .. folder options.

Regards,

Ashwin A

[ashwin]

If SQLyog is already opened and if you are installing on the same path you will get this error. If this is not the case, can you please tell:

– Are you an administrator user?

– What Windows OS do you use?

– Could you try temporarily to disable what 'security suite' you have?

[ashwin]

Hi Mirel Stoica,

Thanks for the bug report. This issue has been fixed internally and will be available in the next public release.

Regards,

Ashwin A

[ashwin]

We introduced the option 'Change language' in the menu recently. But it is inactive ('greyed out') currently as we don't yet have any translations ready. Currently we are working with the Japanese translator and once done we will work on other languages, of which Brazillian Portuguese is one of them.

[ashwin]

Hello,

Quote:

quise entrar a SQLyog y me pide License Key … nose que poner hay ni tampoco se que poner en Name para poder ejecutar el programa.. Porfavor ayudaaa

saludos

Using Google translate- “I wanted to go to SQLyog and asks me License Key … Nose to put there nor to put in Name to run the program .. Please ayudaaa

regards”

We are not able to understand because Google translate failed to translate properly.

We provide support only in English. You can use Google Translate http://translate.google.com/ to frame your queries. Also, please tell what SQLyog version you are using(Help->About)?

Regards,

Ashwin A

[ashwin]

Please refer FAQ: http://webyog.com/faq/content/27/114/en/introduction-to-the-_sqlyog-job-agent_-sja.html

SJA creates default session file and log file if you do not specify in the command line. If you do not have write permission to the installation folder then SJA cannot create those files which results in an error. In order to avoid this situation please specify the session and log file as mentioned in the FAQ.

Example: “F:SQLyog9.2sja.exe” “F:sja_win.xml” -labc.log -sxyz.xml

[ashwin]

Hi Peter Brooks,

If you have given the sja file path name from program files then please enclose it by double-quotes and check.

Ex: “D:SQLyog Enterprisesja.exe” “C:Program FilesBackupOfMYSQLMASS.xml”

[ashwin]

Hi Stephan,

This feature request is already listed in our issue tracker,

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

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

Regards,

Ashwin A

[ashwin]

Hi DennisM,

If you had copy pasted rows from Excel to SQLyog, then Excel is the source of r. When you copy paste a single cell value, r gets appended to the data. As a work around for this you can copy only the data with in the cell (instead of copying the entire cell) in order to avoid the r getting appended.

Quote:

Why don’t I see any evidence of this when I look at the cell in SQLyog?

Unlike a text/blob field which has multi line edit control, Varchar has a single line edit control because of which characters like r,n(non printable characters) are not visible.

Quote:

How can I search for and remove these LF or CR characters?

You can search for these characters by switching to Text view(Toggle between Grid Mode/Form mode and Text Mode by pressing Ctrl+L). See attached images(Grid and text view). But you cannot remove the characters from SQLyog. You can follow the workaround which I mentioned above to avoid the r getting appended.

Thanks,

Ashwin A

[Author]

Posts