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
14 users online | 14 Guests and 0 Registered
Most popular FAQs
- I get error 1130 "Host is not allowed to ... (460330 views)
- Error no. 2003: Can't connect... (375956 views)
- SQLyog Version History (229161 views)
- Error no. 1045: "Connection denied..." (190239 views)
- Error No. 2005: Unknown MySQL server host... (172256 views)
- Error no. 1251: "Client does not support authentication..." (160672 views)
- Can I use SQLyog with the WINE Windows emulator ... (152329 views)
- What is HTTP-tunneling? (127279 views)
- What Is SSH and SSH-tunneling? (98627 views)
- Introduction to the 'SQLyog Job Agent' (SJA) (96575 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
78 search results
Page 7 out of 8 Pages
- Importing external data: What kind of ODBC databases are supported by SQLyog Import External Data Tool? Answer: Any! Simply. As long as they really are ODBC databases. But let us first define ODBC. We quote the Webopedia: ODBC ...
- Importing external data: What is and what is not imported by the SQLyog Import External Data Tool? Answer: The SQLyog Import External Data Tool as of SQLyog 4.1 and later will importDATA and it will - of course - create the type definitions ...
- Connection problems: I am getting "Protocol Mismatch; Server Version 9; Client Version 10;" Answer: The protocol version 9 is used by MySQL 3.22 and earlier. The current version of SQLyog supports 3.23.x and above. To use it with 3.22 ...
- SSH-tunneling: I get "Could not establish SSH connection. Make sure that the SSH server is running Answer: Please refer to this and this FAQ page ...
- MySQL DATA synchronization: Can I synchronize across different MySQL versions? Answer: The basic working of the Synchronization tool is that it generates a string using the concat_ws(s) function on the columns selected with ...
- 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 ...
- Using the GUI: Can I add my own strings to SQLyog auto-complete? Answer: Yes, you can.And that can be very useful if you have some standard strings used often for naming, commenting etc. Especially if those ...
- MySQL DATA synchronization: Data Synchronization fails when a DATETIME column is used for the Primary Key. Answer: You experience that Data Synchronization fails when a DATETIME column is used for the Primary Key (alone or in conjunction with other columns). You ...
- Importing external data: I get "ERROR: 1136, Column count doesn't match value count at row ..." when using Answer: This is due to an ODBC-driver that uses the 'regional settings' of the client machine when generating the data stream from the source database. ...
- Using the GUI: Can I use functions with SQLyog DATA and RESULT panes? Answer: Yes! This has been supported since version 5.12. Also read here about KEYWORDS support in SQLyog GUI. If you enter a string followed by the ...