Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program
- Connection issues
- Using the GUI
- Managing your MySQL Database Systems
- Database Schema Synchronization
- MySQL DATA synchronization
- SQL Scheduler and Reporting Tool
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)
- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Sitemap
23 users online | 23 Guests and 0 Registered
Most popular FAQs
- I get error 1130 "Host is not allowed to ... (460356 views)
- Error no. 2003: Can't connect... (375978 views)
- SQLyog Version History (229184 views)
- Error no. 1045: "Connection denied..." (190258 views)
- Error No. 2005: Unknown MySQL server host... (172279 views)
- Error no. 1251: "Client does not support authentication..." (160697 views)
- Can I use SQLyog with the WINE Windows emulator ... (152354 views)
- What is HTTP-tunneling? (127297 views)
- What Is SSH and SSH-tunneling? (98649 views)
- Introduction to the 'SQLyog Job Agent' (SJA) (96595 views)
Latest FAQs
- SQLyog Version History (2014-06-08 10:22)
- I get error 1130 "Host is not allowed to ... (2014-01-30 12:21)
- About CHUNKs and BULKs (2014-01-09 11:53)
- SQLyog is a client for the MySQL server - ... (2013-08-04 04:48)
- Problems creating a functional DSN on 64 bit Windows. ... (2013-07-22 08:34)
Sticky FAQs
Advanced search
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 ...