[Kartik Grover]

Hi 

 

Can you please send the screenshots of the object browser in the cases of the source and target (before and after the copy that you do)? For security reasons I would suggest you to write to us at [email protected]. The forums may not be the right place to share your data or screenshots for that matter.

 

Regards

[Kartik Grover]

Hi

 

The MySQL documentation states the following in regards to hand;e case sensitivity: To avoid data transfer problems arising from lettercase of database or table names, you have two options:

• Use lower_case_table_names=1 on all systems. The main disadvantage with this is that when you use SHOW TABLES or SHOW DATABASES, you do not see the names in their original lettercase.

• Use lower_case_table_names=0 on Unix and lower_case_table_names=2 on Windows. This preserves the lettercase of database and table names. The disadvantage of this is that you must ensure that your statements always refer to your database and table names with the correct lettercase on Windows. If you transfer your statements to Unix, where lettercase is significant, they do not work if the lettercase is incorrect.

  Exception: If you are using InnoDB tables and you are trying to avoid these data transfer problems, you should set lower_case_table_names to 1 on all platforms to force names to be converted to lowercase.

Please refer to this article for more details: http://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html

 

Regards

 

[Kartik Grover]

Hi 84hurd

 

Have you tried our tool MONyog to monitor your MySQL servers? Please go to http://www.monyog.com and start your free trial today. If any issues please feel free to write to [email protected] or [email protected].

[Kartik Grover]

Hi

 

Sorry there is a small correction. As you said MySQL does store the comments but only that lie inside the routine definition. If you have tried to comment anything outside the Routine definition, that is not being saved. 

 

Regards

[Kartik Grover]

I don’t think so that even putting a “#” would save the changes. Please check that there are two cases here that are possible. One is that you add comments to the SP and then close only the tab of SP and second is closing SQLyog altogether and opening again.

 

As you would know that the comments fall into metadata of a stored procedure, views, etc. MySQL does not save comments for the SP or views for that matter. You can check the information_schema for the data. The mysql documentation explains that here http://dev.mysql.com/doc/refman/5.0/en/views-table.html or running the query:

SHOW CREATE PROCEDURE ; 

does not contain comments anywhere.

 

So in the first case where you close the SP tab without saving it in a .sql file there is no way server will remember the changes.

 

But in the second case where you close SQLyog the changes that you made to any editing tab, may it be SP or query editing the changes that you made will be saved due to Session restore that SQLyog offers. Please note here that SQLyog is saving whatever there is on the editor tab, not the server. So we cannot do much in this case.

[Kartik Grover]

Hi

 

Please tell if commenting out using ‘#’ saves the Stored Procedure or not?

[Kartik Grover]

Hi

 

This is reproducible at our end. We are considering the implementation aspects for fixing this. Thanks in advance for your patience.

 

Regards

[Kartik Grover]

Hi

 

We have had some similar requests before but we have been more concerned with the risks involved in implementing it through GUI. As a single click will execute a synchronisation job that may go wrong for a user.

So long time back we came up with a solution for this. You can run the SJA to run the jobs that you have saved via command line. Here you can read about it more

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

 

Now to execute it in a single click this FAQ answers it completely

>> http://faq.webyog.com/content/27/74/en/how-do-i-execute-a-job-with-sja-with-a-single-mouse_click.html.

 

Regards

[Kartik Grover]

Hi

 

Please refer to the detailed list of the features that our paid versions have here  > https://www.webyog.com/product/sqlyogFeatureListExpanded

 

The features listed above are not added in the community version. 

 

Regards

[Kartik Grover]

Hi

 

Have you tried mentioning the content type in the advanced section of HTTP connection? Please refer to our documentation here..>> 

http://sqlyogkb.webyog.com/article/155-connecting-using-http-tunneling

 

It states that “With Apache and mod_security extension enabled in Apache configuration it may be necessary to use ‘urlencode’.” Please try and use “urlencode” HTTP content type and check if the problem still persists.

 

Regards

[Kartik Grover]

Hi

 

WE are not able to understand what you are referring to. Please be specific and give some details about the problems you are facing.

[Kartik Grover]

Hi

 

What you are expecting from SQLyog actually comes under monitoring of your servers. SQLyog just GUI tool fro MySQL and this sort of a thing is out of scope in regards to SQLyog’s usage. If you want to view your old queries fired on the server you may take a look at another product we have, called MONyog. It can help you view your queries going back and forth in the time. Here you can read about it more >> https://www.webyog.com/product/monyog

 

Regards

[Kartik Grover]

Hi Christophe,

 

We have added the feature you requested. Now you can open multiple files from File browser in SQLyog. Please refer to the blog post for more details..>> 

 

http://blog.webyog.com/2016/02/09/sqlyog-mysql-gui-12-19-released/

 

-Kartik

[Kartik Grover]

Hi 

 

We have a similar request in our issue tracker over here >>https://github.com/webyog/sqlyog-community/issues/2085

 

I have added yours in the same thread. Although, yes the implementation is still not decided upon but the idea here is to ease the search when there are multiple tabs opened.

 

Kartik

[Kartik Grover]

Hi Zaph,

 

Please write us to [email protected] or [email protected]. We will look into it surely. We cannot discuss any licence issues here on the forums for security reasons. If you have sent any emails to anyone of these mail IDs, may I please know which one did you write to? We will look into how was this missed.

 

Regards

[Author]

Posts