Please note: If this FAQ s empty you must choose English language from the drop-down-box below. Only English content is available as of now!
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
- Notification Services
- 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
- Instant Response
- Sitemap
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (115398 views)
- Error no. 2003: Can't connect... (52114 views)
- Error no. 1251: "Client does not support authentication..." (48094 views)
- Error no. 1045: "Connection denied..." (41348 views)
- SQLyog Version History (39958 views)
- What is HTTP-tunneling? (29296 views)
- Error No. 2005: Unknown MySQL server host... (28370 views)
- What Is SSH and SSH-tunneling? (25497 views)
- Why are Stored Procedures not created when I import ... (23463 views)
- Do I need PHP to use SQLyog with MySQL? ... (21521 views)
Latest FAQs 
- SQLyog Version History (2010-03-09 03:20)
- SQLyog is a client for the MySQL server - ... (2009-09-11 07:48)
- Can I use SQLyog with the various SQL-modes available ... (2009-08-20 08:02)
- Failed dependency for libstdc++.so.5 error (2009-08-13 11:22)
- Wrong results are returned for FOUND_ROWS(). (2009-08-12 06:31)
About the SQLyog program » General Use
Error messages
SQLyog will present you for different types of errors:
1) MySQL server errors. They are described here. They all have a 4 digit number starting with "1". An example is "Error: 1452: Cannot add or update a child row: a foreign key constraint fails (%s)". The error message is sent by the MySQL server itself to SQLyog and printed on the screen for your reference.
2) MySQL client errors. They are described here. They all have a 4 digit number starting with "2". An example is "Error: 2006: MySQL server has gone away". Obviously this error can't be a server error, because you can't communicate with a server that has 'gone away'! They originate from the MySQL API/client that is compiled into SQLyog.
3) Error messages originating from SQLyog itself. They are un-numbered/pure text only.
4) Communication/protocol errors. HTTP errors can occur when using HTTP-tunneling. SQLyog will then always display "HTTP error: ....."
When faced with an error message (to which the solution is not obvious) it is normally a very good idea to start realizing in what category the error falls. If it is a server error then the connection is still alive for instance. And also when posting in the Forums or contacting Webyog e-mail support, please always note down (or have a screenshot) the exact error number and -message. It is very hard to help or research into something like "I did this and had an error".
Tags: -
Related entries:
- Installation and upgrading
- SQLyog Version History
- Error No. 2005: Unknown MySQL server host...
- Error no. 1045: "Connection denied..."
- Error no. 2003: Can't connect...
Last update: 2006-01-22 22:37
Author: Peter Laursen
Revision: 1.0
You can comment this FAQ
Comment of Vojtech Klima:
I would apreciate link to list of description of SQLyog error here + tips how to overwhelm them.
Added at: 2006-08-20 21:04