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
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (115201 views)
- Error no. 2003: Can't connect... (51979 views)
- Error no. 1251: "Client does not support authentication..." (48041 views)
- Error no. 1045: "Connection denied..." (41265 views)
- SQLyog Version History (39857 views)
- What is HTTP-tunneling? (29222 views)
- Error No. 2005: Unknown MySQL server host... (28259 views)
- What Is SSH and SSH-tunneling? (25442 views)
- Why are Stored Procedures not created when I import ... (23378 views)
- Do I need PHP to use SQLyog with MySQL? ... (21478 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)
Database Schema Synchronization
Does the SQLyog 'Schema Sync Tool' synchronize the order-of-columns within a MySQL database table?
Yes! That was included with SQLyog version 5.1. The SCHEMA SYNC tool now syncs all available information from the database schemas and can be used across all MySQL versions with these exceptions:
1) it does not 'strip out' partition information when syncing MySQL 5.1 partitioned tables to MySQL 5.0 (it does when syncing to versions before that).
2) MySQL TABLESPACES (introduced in MySQL 5.1 for NDB tables and in 6.0 for FALCON tables) are not sync'ed. This limitation applies to the TABLESPACE itself as well as TABLESPACE usage in CREATE TABLE statements
Note that charset/collation 'defaults' for databases, and tables are synced from version 6.0 and charset/collation information for individual columns is sync'ed from version 6.1. Support for EVENTS was added in version 6.5
Note that to use the SQLyog/SJA data sync -functionality the order-of-tables must be identical. The structure sync tool as of SQLyog 5.1 will make that easy for you! However you can also use the 'reorder columns' functionality of the TABLE -menu or -pop-up-menu.
Also read this note on case-sensivity
Tags: -
Related entries:
- Do I need PHP to use SQLyog with MySQL?
- SQLyog gives you the most options for connecting to MySQL
- Welcome to the Webyog FAQ
- Installation and upgrading
- Buying and Licensing SQLyog
Last update: 2009-02-16 05:04
Author: Peter Laursen
Revision: 1.2
You can comment this FAQ