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 ... (462187 views)
- Error no. 2003: Can't connect... (377832 views)
- SQLyog Version History (231020 views)
- Error no. 1045: "Connection denied..." (191950 views)
- Error No. 2005: Unknown MySQL server host... (174036 views)
- Error no. 1251: "Client does not support authentication..." (162499 views)
- Can I use SQLyog with the WINE Windows emulator ... (154140 views)
- What is HTTP-tunneling? (128978 views)
- What Is SSH and SSH-tunneling? (100413 views)
- Introduction to the 'SQLyog Job Agent' (SJA) (98343 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 11 out of 14 Pages
- Program versions: Where can I download old program versions? Answer: Nowhere!With each new SQLyog version we constantly add features, improve usability, improve performance and - not to forget - fix bugs and add/change code to ...
- Manipulating data.: Can I use the auto_increment attribute without using that column as a Primary Key. Answer: 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 ...
- Foreign Keys/relationships: I have Foreign Keys and they work but there are a lot of weird names Answer: To create a Foreign Key/relationship in MySQL you (or SQLyog) must send a CREATE TABLE or ALTER TABLE SQL-statement likealter table ´Test´.´TableName´ add constraint ´ConstraintName´ ...
- Character Set and Localization Issues: My special characters display as 'noisy' Latin characters in SQLyog! Answer: Most likely the reason for this is that the install script of the application that is used with the data did not explicitly create databases ...
- HTTP(s)-tunneling: What should permissions be for the SQLyog tunneller file? Answer: We recommend the permission setting for the SQLyog tunneller file to be (in octal notation) 644. That means read permission for both 'owner', 'group' and ...
- Importing external data: Migration of columns defaults from MS Access fails with SQLyog Import External Data Tool. Answer: You experience that when importing data from Microsoft Access migration of columns defaults fail. This is a confirmed issue and we believe it is a problem ...
- Working with Views, Stored Procedures and Triggers: Nested C-style comments fail with MySQL 5.1 Answer: Nested comments written like /* external /* internal comment */ comment */ fail to execute with MySQL 5.1 and higher. It works before that. That is ...
- SSH-tunneling: SQLyog takes long time to connect when using SSH-tunnel. Answer: If SQLyog is taking long time (more than 5-10 seconds) to connect to your MySQL server using SSH tunneling then there could be problem with ...
- About Webyog support and about this FAQ: SQLyog is a client for the MySQL server - but what server versions are supported? Answer: The points below summarizes the situation as of August 2013: 1) We support MySQL versions (whether official MySQL builds or 'fork' builds) from 4.1.x and ...
- Program versions: Are there restrictions in the SQLyog TRIAL compared to the REGISTERED versions? Answer: The TRIAL is identical to SQLyog Ultimate with the the restrictions: * At startup as well as at exit it will show a window displaying how ...