Mysql Data Synchronization:

[peterlaursen]

NULL-mismatch is not a problem with the DATA but with the STRUCTURE of the table. One or more colums are defined differently as 'NULL' og 'NOT NULL' in the databases. Structure must be totally identically for the sync tool to work. That include NULL/NOT NULL, DEFAULTS and INDEXES. You can use the ALTE TABLE functionality og SQLyog to make structure identically

The NULL mismatch also can occur with MySQL databae versions that are “too much different” for the sync. Read a little about it here: http://www.webyog.com/faq/10_68_en.html. But you did sync once, so that is probably not the problem (if the two databases were the same the two times)

If this won't help you we don't need the DATA but the CREATE STATEMENT for the table (You can copy it from the OBJECTS pane in SQLYOG) and the ecact MySQL server versions. If you don't know the query

Code:

Select version();

returns the MySQL server version.

[Author]

Posts