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
 
                0 users online | 0 Guests and 0 Registered
                
            Most popular FAQs 
            - I get error 1130 "Host is not allowed to ... (491092 views)
 - Error no. 2003: Can't connect... (406957 views)
 - SQLyog Version History (259489 views)
 - Error no. 1045: "Connection denied..." (218109 views)
 - Error No. 2005: Unknown MySQL server host... (201175 views)
 - Error no. 1251: "Client does not support authentication..." (189906 views)
 - Can I use SQLyog with the WINE Windows emulator ... (181937 views)
 - What is HTTP-tunneling? (155626 views)
 - What Is SSH and SSH-tunneling? (127440 views)
 - Introduction to the 'SQLyog Job Agent' (SJA) (125643 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
133 search results
Page 13 out of 14 Pages
- 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. ...
 - Backup/Restore: Can I back up more databases at one time? Answer: Yes! Support for this was added in the Scheduled Backup 'powertool' in SQLyog version 6.5. You can backup everything from the databases where you have ...
 - Backup/Restore: How should I use the various options of the SQLyog backup 'powertool'? Answer: We cannot decide that on your behalf! We have provided the most flexible options available including:* An option to backup a complete database or only ...
 - Purchasing and Licensing: How do I ensure that I always have the latest available SQLyog version? Answer: The answer is simple: Just subscribe to the 'News' section of our Forums and you will be notified whenever a new release (BETA, RC ...
 - Importing external data: I get ZERO's when importing DATE and TIME types Answer: It is an issue with the data type. DATE and TIME data types - and their implementations - differ quite a lot across database systems. ...
 - Purchasing and Licensing: Upgrade Policy Answer: A license for SQLyog Professional, Enterprise and Ultimate is bundled with a 1-year subscription. After that you must purchase an upgrade in order still ...
 - SQL Scheduler and Reporting Tool: Can I schedule CSV export and import? Answer: The CSV export and import functionality of the SQLyog GUI are not directly implemented in the SJA. But both are posible with relative simple SQL ...
 - 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 ...
 
