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
9 Users online :: 9 Guests and 0 Registered
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (115380 views)
- Error no. 2003: Can't connect... (52096 views)
- Error no. 1251: "Client does not support authentication..." (48093 views)
- Error no. 1045: "Connection denied..." (41340 views)
- SQLyog Version History (39954 views)
- What is HTTP-tunneling? (29291 views)
- Error No. 2005: Unknown MySQL server host... (28363 views)
- What Is SSH and SSH-tunneling? (25494 views)
- Why are Stored Procedures not created when I import ... (23460 views)
- Do I need PHP to use SQLyog with MySQL? ... (21519 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)
C
A B C D E F H I M N O P S T U W
- Can I use SQLyog with MySQL version 5 features like Views, Stored Procedures and Triggers
Yes, you can. From version 5.0 SQLyog supports these features. The DELIMITER command is implemented in the SQLyog editor like in the ... - Can I use HTTP-tunneling if I don't have PHP at my webhost
As of now the answer is NO. PHP must be available and either the php_mysql() or the php_mysqli() extension or extension must be enabled ... - Can I execute more SJA jobs at the same time?
Well, Yes you can. Absolutely no problem in doing so.But the result of it may be unpredictable in cases where one or more of ... - Can I change my database name(s)
NO ... and yes!Directly changing database names is not possible! It is not a restriction with SQLyog, but with MySQL itself. The reason is that ... - Can I synchronize across different MySQL versions?
The basic working of the Synchronization tool is that it generates a string using the concat_ws(s) function on the columns selected with ... - Can I manage MySQL databases with SQLyog if database or column names are in a different language than my own?
Yes! No problems!Read about SQLyog and character sets here. Also if the names of database objects use characters that are not available on your ... - Can I use SQLyog with the WINE Windows emulator on LINUX.
Yes - most often you can. We have had reports of users successfully doing so for quite a while. We have tested that ... - Can I use SQLyog with the various SQL-modes available with MySQL?
Well ... yes. But let us have a look of the concept of the sql-modes.SQL-modes were introduced with MySQL version 4.0 as a general ... - Can I perform "incremental import" with the SQLyog Import External Data Tool?
Yes! The SQLyog Import External Data Tool was developed with that feature in mind from the very beginning. To do this you must understand ... - Can I do a 'Silent Install' when installing SQLyog?
Yes, you can!Network Administrators generally have the most use for a silent install. What a silent install does is to install the application ... - Can I rename a database?
NO... and yes! Directly changing database names is not possible! It is not a restriction with SQLyog, but with MySQL itself. The reason is that ... - Can I add my own strings to SQLyog auto-complete?
Yes, you can.And that can be very useful if you have some standard strings used often for naming, commenting etc. Especially if those ... - Can I manually edit the SQLyog tunneling file?
Yes, of course you can. The PHP language is human readable. You just need a simple text editor. But there will generally be ... - Can I change the registration info after SQLyog was installed?
Yes! Common reason why you would want to do this are: you misspelled the registration name when purchsing. by mistake you registered ... - Can I use functions with SQLyog DATA and RESULT panes?
Yes! This has been supported since version 5.12. Also read here about KEYWORDS support in SQLyog GUI. If you enter a string followed by the ... - Can I compress (.zip) SQLyog/SJA backups?
There is no functionality for compressing backup (.sql) files in the sja-code itself. However as the SJA is a command-line tool it can ... - Can I back up more databases at one time?
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 ... - Can I use the auto_increment attribute without using that column as a Primary Key.
Yes! MySQL allows for that. The rules are:There can only be one auto_increment column in a tableThis column must be defined as a KEYWe ... - Contribution Agreement
As any company delivering Open Source program(s) operating in a world dominated by proprietary licenses and where legal issues with intellectual property rights occur and ... - Can I store 'long strings' in BLOBs with SQLyog?
Yes, you can. But basically you should consider a better option! BLOB types are 'BINARY LONG' data. It is intended for storing binary data ... - Can I restore a backup on another server than where it was created?
Yes, you can. But please first also read this FAQthat explains the basics about the backup functionalities in SQLyog. As long as the 'main' Server versions are identical ... - Can I schedule CSV export and import?
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 ...