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 ... (466302 views)
- Error no. 2003: Can't connect... (382054 views)
- SQLyog Version History (234982 views)
- Error no. 1045: "Connection denied..." (195692 views)
- Error No. 2005: Unknown MySQL server host... (177889 views)
- Error no. 1251: "Client does not support authentication..." (166423 views)
- Can I use SQLyog with the WINE Windows emulator ... (158141 views)
- What is HTTP-tunneling? (132736 views)
- What Is SSH and SSH-tunneling? (104286 views)
- Introduction to the 'SQLyog Job Agent' (SJA) (102217 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
H
A B C D E F H I M N O P S T U W
- How do I schedule a job?
There are two ways to do that (on Windows): 1) Using the Wizard ("powertools" menu).If you create a new job the last screen of the wizard ... - How do I create ENUM and SET data types with SQLyog?
The implementation in MySQL for defining ENUM and SET types is so that the list of valid values are specified with the same syntax as ... - How can I speed up the SQLyog Synchronization tool?
There are four important aspects of this:1) You must have sufficient bandwidth from the computer where the SQLyog Job Agent (SJA) is running to the ... - How do connection names resolve to ip's?
NOTE: This is not a typical FAQ article. It does not answer questions about the SQLyog program as such. But we experience quite ... - How do I execute a job with SJA with a single mouse-click?
Being able do so can be practical if you want someone to be able to execute the SJA with some preconfigured jobfile without having any ... - How does the SQLyog backup work?
In addition to the direct 'export' option in the database and table menus, the backup functionalities of SQLyog Enterprise and SQLyog Ultimate is implemented in ... - How do I control the parameters of DECIMAL data types with SQLyog?
You can do that as attached picture explains.In the "Len" -column you write the parameters divided by comma " , ". This explanation applies ... - How does SQLyog handle TIMESTAMPS defined as '... on UPDATE CURRENT_TIMESTAMP' ?
You can read about SQLyog 'smart' KEYWORD handling introduced with SQLyog 5.1 here. When updating any TIMESTAMP defined with '... on UPDATE ... - How should I use the various options of the SQLyog backup 'powertool'?
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 ... - How do I ensure that I always have the latest available SQLyog version?
The answer is simple: Just subscribe to the 'News' section of our Forums and you will be notified whenever a new release (BETA, RC ... - How shall I understand the 'query execution time' that SQLyog gives me?
SQLyog displays 'query execution time' for each query in three different places: The STATUS bar/line, the MESSAGES tab and the HISTORY tab. Let us explain what ... - How Do I Remove Duplicates From My Databases?
Removing duplicate rows from database tables can be a problem. The problem is that with the common SQL syntaxDELETE FROM mytable WHERE {where condition};.. ... - How do I define TIMESTAMP properties with SQLyog?
The TIMESTAMP datatype is the MySQL datatype that causes most problems. Basically there are three reasons for this * The implementation for the TIMESTAMP type ... - How can SQLyog handle import of DUMPs with tables using Foreign Keys with HTTP tunnel?
This question has been asked sometimes by people having noticed that SQLyog (just like the 'mysqldump' program for instance) generates a SQL-DUMP like SET @old_FOREIGN_KEY_CHECKS = ... - How can I run SQLyog from a portable drive.
With a normal installation SQLyog will (since version 6.06) not write its configuration file ('SQLyog.ini') as well as the 'favorites' folder and the local SQLite ...