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
25 users online | 25 Guests and 0 Registered
Most popular FAQs
- I get error 1130 "Host is not allowed to ... (460350 views)
- Error no. 2003: Can't connect... (375974 views)
- SQLyog Version History (229177 views)
- Error no. 1045: "Connection denied..." (190254 views)
- Error No. 2005: Unknown MySQL server host... (172272 views)
- Error no. 1251: "Client does not support authentication..." (160693 views)
- Can I use SQLyog with the WINE Windows emulator ... (152348 views)
- What is HTTP-tunneling? (127293 views)
- What Is SSH and SSH-tunneling? (98644 views)
- Introduction to the 'SQLyog Job Agent' (SJA) (96590 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
131 search results
Page 12 out of 14 Pages
- General questions about SJA: Why is my Scheduled Job not Running? Answer: If that happens it is not an issue with SQLyog!First you must understand that any job running on Windows is running with some user privileges. ...
- Manipulating data.: Is there a built-in encryptor in SQLyog compatible to phpMyAdmin SHA1 -encryptor? Answer: No, as of now there is not. It is on the TODO. Priority of this has not been decided yet. ...
- 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 ...
- Connection problems: I have a very long username for the MySQL database at my ISP. SQLyog Answer: Right! Because a MySQL user name is up to 16 characters long. The MySQL docs clearly state:MySQL usernames can be ...
- MySQL DATA synchronization: I get error "Column NAME mismatch for '´database´' table " when running datasync. Answer: A "column NAME mismatch" can be eithersimply a column name mismatch! Columnnames must be identical as tablenames must. Just like you can't sync a ...
- Manipulating data.: I execute a query but it is not written to HISTORY. Answer: You experience that when you execute a query it is not written to HISTORY. The query itself executes correctly.The reason is that ...
- Using the GUI: Why have my 'favorites' disappeared? Answer: The 'Favorites' feature introduced With SQLyog 5.1 (replacing the old 'Personal Folder' feature) saves a user's favorites in that users 'application data' folder on ...
- MySQL bugs that affect SQLyog: When adding a TIMESTAMP column to an existing table ZERO-dates are inserted Answer: You experience that when adding a TIMESTAMP column to an existing table (with existing rows in it) using the definition:´ts´ timestamp NOT ...
- 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. ...