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
10 users online | 10 Guests and 0 Registered
Most popular FAQs
- I get error 1130 "Host is not allowed to ... (460352 views)
- Error no. 2003: Can't connect... (375976 views)
- SQLyog Version History (229179 views)
- Error no. 1045: "Connection denied..." (190256 views)
- Error No. 2005: Unknown MySQL server host... (172276 views)
- Error no. 1251: "Client does not support authentication..." (160695 views)
- Can I use SQLyog with the WINE Windows emulator ... (152350 views)
- What is HTTP-tunneling? (127295 views)
- What Is SSH and SSH-tunneling? (98647 views)
- Introduction to the 'SQLyog Job Agent' (SJA) (96593 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 13 out of 14 Pages
- 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 ...
- Database Schema Synchronization: Problem with string default '' (empty string) and Schema Synchronisation Answer: You experience that Schema Sync finds no difference for a string type declared NOT NULL default '' (empty string) and NOT NULL (with no default). This ...
- Using the GUI: Wrong results are returned for FOUND_ROWS(). Answer: FOUND_ROWS() is an 'information function' in MySQL. The use of it is that you can use a LIMIT clause to reduce the result set and ...
- About the SQLyog program: Data get truncated when importing a large CSV-file. Answer: SQLyog is is able to import data CSV files to MySQL using two different techniques: 1) using the Microsoft ODBC Text driver (that ships with every ...