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 ... (115368 views)
- Error no. 2003: Can't connect... (52084 views)
- Error no. 1251: "Client does not support authentication..." (48087 views)
- Error no. 1045: "Connection denied..." (41330 views)
- SQLyog Version History (39943 views)
- What is HTTP-tunneling? (29282 views)
- Error No. 2005: Unknown MySQL server host... (28336 views)
- What Is SSH and SSH-tunneling? (25485 views)
- Why are Stored Procedures not created when I import ... (23452 views)
- Do I need PHP to use SQLyog with MySQL? ... (21514 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)
MySQL DATA synchronization
ID #1068
I get error "Column NAME mismatch for '´database´' table " when running datasync.
A "column NAME mismatch" can be either
- simply a column name mismatch! Columnnames must be identical as tablenames must. Just like you can't sync a table named my_table in one database with another named mytable in another database, you can't sync a column named my_column in one table with another named mycolumn in another table.
- or the error can occur because the column order differs between the two tables. The column order must be identical for the sync tool to work! This is because the sync tool internally uses an XML-format. As such it is a text-based format and it is in its nature 'linear' or 'sequential'. You must use the 'reorder columns' functionality available from the Table -menu or -pop-up-menu to create an identical column order before syncing. SQLyog version 5.1 will allow you to use the Structure Sync Tool for this.
Note that
- There is no similar order-issue with MySQL version 5 objects. They always occur in alphabetical order no matter in what order they were created.
- Column names are NOT case-sensitive in MySQL - and that applies to UNIX/LINUX as well! So you may sync my_column and MY_COLUMN in table my_table in two different databases - also on *nix. However table names ARE case sensitive on UNIX/LINUX so on these platforms you can't sync my_table and MY_TABLE. On Windows you can!
Also note that Table case-sensitivity with *NIX and non-case-sensitivity with Windows (and sometimes MAC, depending on the filesystem on which it is installed) are DEFAULTs for the systems. The behavior can be changed with the 'lower_case_table_names' system variable on all platforms.
Tags: -
Related entries:
- Installation and upgrading
- Buying and Licensing SQLyog
- SQLyog Version History
- Can I perform "incremental import" with the SQLyog Import External Data Tool?
- Error messages
Last update: 2005-12-08 18:04
Author: Peter Laursen
Revision: 1.0
You can comment this FAQ