Mysql Data Synchronization:

[peterlaursen]

I am testing the data synchronization. I have a local MySQL database and a remote database. I tried to schedule a synchronization from a local table to the remote table and it worked. Next I copied a small 5 record table from the remote MySQL DB to my local MySQL DB. I then emptied the table in the remote DB and tried to see if I can synchronize the 5 records from the local database to the remote database. I get the error: NULL definition mismatch for 'CTNNumber' column in '`receivemsg`' table My data is simple as shown below: “CTNNumber” “PhoneNo” “recipientname” “recipientrelation” “recvtime” “H2000” “93424243” “Charlie Lugay” “Brother” “1300” “J1000” “23212323” “Mae Pimentel” “Sister” “1200” “O5000” “98765432” “Maileen” “Mother” “1600” “Q4000” “12345678” “Kaye” “Sister” “1500” “R3000” “94343” “Ryan” “Brother” “1400” What does this mean?

[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