[Abhishek Kumar Pandey]

Hi,

 

Try catch is not used in MySQL. 

Mostly error handling in stored procedure is done by DECLARE … HANDLER please refer-http://dev.mysql.com/doc/refman/5.7/en/declare-handler.html

 

You can use this in stored procedure to execute some specific task if error occurred(same as you do in catch) and then exit or continue.

 

To  derive the exact nature of the error you can use GET DIAGNOSTICS please refer-http://dev.mysql.com/doc/refman/5.6/en/get-diagnostics.html

 

SQLyog doesn’t have any specialized way of doing error handling.

[Abhishek Kumar Pandey]

It seems issue with google url shortner.

 

Please download from these links-

SQLyog community 64 bit-https://s3.amazonaws.com/SQLyog_Community/SQLyog+12.04/SQLyog-12.0.4-0.x64Community.exe

SQLyog community 32 bit-https://s3.amazonaws.com/SQLyog_Community/SQLyog+12.04/SQLyog-12.0.4-0.x86Community.exe

[Abhishek Kumar Pandey]

Thank you for reporting we are fixing it.

[Abhishek Kumar Pandey]

Hi ,

 

Please paste the SQL dump file created by SQLyog using Ignore DEFINER option. Also please note that the target server will create DEFINER as current SQLyog user when creating the functions.

[Abhishek Kumar Pandey]

Same as your another post here-http://forums.webyog.com/index.php?showtopic=7588&hl=

 

I am quoting the same “Issue is reproducible only in wine. We tried same in windows 7/8/8.1 but this behavior is not reproducible in Windows. We will try to fix it but you should understand It may be related to wine architecture of message handling and painting we can’t give you a exact time frame for fix.“

[Abhishek Kumar Pandey]

Issue is reproducible only in wine. We tried same in windows 7/8/8.1 but this behavior is not reproducible in Windows. We will try to fix it but you should understand It may be related to wine architecture of message handling and painting we can’t give you a exact time frame for fix.

[Abhishek Kumar Pandey]

Hi,

 

Thank you for reporting this issue.

We also observed that SQLyog editor’s behavior is not same as other editors on pressing END key if word wrap is enabled. We have used third party library in SQLyog for rich editing experience of users and it seems their implementation of word wrap is not identical with winapi (atleast on END key). Anyways I have added this issue here-https://code.google.com/p/sqlyog/issues/detail?id=2070

We will look into it and update more here.

 

And we are sorry It took more than a week to reply here.

[Abhishek Kumar Pandey]

We have released SQLyog 12.04 including this fix. Please refer-http://blog.webyog.com/2014/12/23/sqlyog-mysql-gui-12-04-released/

[Abhishek Kumar Pandey]

Hit F1 in SQLyog, goto version history. You may also refer to-http://blog.webyog.com/category/sqlyog/

[Abhishek Kumar Pandey]

We are trying to reproduce it at our end. We will update here more about it.

[Abhishek Kumar Pandey]

Hi,

These are non-released builds for you including fix for this crash-

SQLyog Community 32 bit-http://goo.gl/EpUMtW

SQLyog Community 64 bit-http://goo.gl/R6D70K

 

Please download and provide your feedback. We will include this fix in next public release also. 

[Abhishek Kumar Pandey]

It seems to be problem with library we use in SQLyog. We are working on it. However we have found that if you create new connection with same details (hit CTR+N) the problem doesn’t occurs in any connection. 

[Abhishek Kumar Pandey]

Hi Scott,

 

Session restore saves all your session details on exit and thus It can cause some delay. Delay also depends on number of open connection tab, query tab etc. You can turn off session restore open tools->preferences->others here uncheck restore session on strartup.

[Abhishek Kumar Pandey]

Hi,

 

I do’t know what are your exact requirements but as far as I can understand, you want to copy database from one MYSQL server to another MYSQL server. If I understand correct that you can do this with Database synchronization tool. Please refer-https://static.webyog.com/docs/SQLyog/Data_Base_Synchronization_SQLyog_MySQL_Management_Tool.htm

[Author]

Posts