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
7 Users online :: 7 Guests and 0 Registered
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (128704 views)
- Error no. 2003: Can't connect... (58523 views)
- Error no. 1251: "Client does not support authentication..." (50541 views)
- Error no. 1045: "Connection denied..." (46251 views)
- SQLyog Version History (45077 views)
- Error No. 2005: Unknown MySQL server host... (33381 views)
- What is HTTP-tunneling? (32471 views)
- What Is SSH and SSH-tunneling? (28002 views)
- Why are Stored Procedures not created when I import ... (27057 views)
- Do I need PHP to use SQLyog with MySQL? ... (23936 views)
Latest FAQs 
- SQLyog Version History (2010-09-02 04:20)
- Do I need to replace the PHP tunneler file ... (2010-03-25 10:26)
- Data get truncated when importing a large CSV-file. (2010-03-18 12:30)
- 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)
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