29 search results

Page 1 out of 3 Pages

• Program versions: SQLyog Version History
  
  Answer: Please refer relevant page in online documentation ...
  
  
• Working with Views, Stored Procedures and Triggers: Problems with CREATE/ALTER 'stored program' when server binary log is enabled.
  
  Answer: You may enocunter the situation where creation/alteration of a 'stored program' (Procedure/Function/Trigger/Event) fails to create even if user has appropirate (like CREATE ROUTINE or ALTER ...
  
  
• SQL Scheduler and Reporting Tool: Is it possible to execute Stored Procedures from SQLyog/SJA 'SQL Scheduler and Reporting Tool'?
  
  Answer:   Yes, it is -Provided - of course - that the MySQL server version supports this. To execute a Stored Procedure simply include this SQLcall ...
  
  
• Working with Views, Stored Procedures and Triggers: Can I use SQLyog with MySQL version 5 features like Views, Stored Procedures and Triggers
  
  Answer:   Yes, you can. From version 5.0 SQLyog supports these features. The DELIMITER command is implemented in the SQLyog editor like in the ...
  
  
• Working with Views, Stored Procedures and Triggers: Why are Stored Procedures not created when I import an SQL-file?
  
  Answer:   This is a privilege issue.You will probably get the error 1044 "Access denied ..." or 1370 "Alter routine command denied to user ...". ...
  
  
• Using the GUI: Do I need to SET NAMES to display characters of my language?
  
  Answer: No, you won't. SQLyog does all what is required! With the introduction of SQLyog version 6 SQLyog always uses UTF8 internally. Whenever SQLyog communicates ...
  
  
• Backup/Restore: Does the SQLyog backup tool backup MySQL ver. 5 Objects?
  
  Answer:   Yes it does!Stored Procedures, Functions, Triggers and Views are all backed up by the SQLyog backup tool (and restored by the restore functionality). That ...
  
  
• Working with Views, Stored Procedures and Triggers: Nested C-style comments fail with MySQL 5.1
  
  Answer:   Nested comments written like /* external /* internal comment */ comment */ fail to execute with MySQL 5.1 and higher.  It works before that.  That is ...
  
  
• Copy data between different hosts: MySQL 5 objects are greyed out in "copy DB to other host" dialogue.
  
  Answer:   MySQL version 5 objects (Views, Stored Procedures and Functions) are greyed out in "copy DB to other host" dialogue and the objects are not created ...
  
  
• Database Schema Synchronization: Does the SQLyog 'Schema Sync Tool' synchronize MySQL objects (Stored Procedures, Functions, Triggers, Views and
  
  Answer:   Yes, it does! That was included with SQLyog version 5.1. The SCHEMA SYNC tool now syncs all available information from the database schemas ...
  
  

1  2  3  next  >>