Data Syncronization Wizard

[barryccampbell]

When I use the Database Syncronization Wizard to sync my local Database with my Yahoo! Database, I get an error:

Code:

NULL definition mismatch for 'CompanyID' column in '`apparel_jewelry`' table

When viewing the table “4 Objects” in the panels, I notice that the Primary Key Null is blank on my Yahoo Database:

Code:

Field        Type          Collation          Null    Key     Default  Extra           Privileges                       Comment
———–  ————  —————–  ——  ——  ——-  ————–  ——————————-  ——-
CompanyID    int(11)       (NULL)                    PRI     (NULL)   auto_increment  select,insert,update,references        

but is set to NO on my local Database:

Code:

Field        Type          Collation          Null    Key     Default  Extra           Privileges                       Comment
———–  ————  —————–  ——  ——  ——-  ————–  ——————————-  ——-
CompanyID    int(11)       (NULL)             NO      PRI     (NULL)   auto_increment  select,insert,update,references        

I tried to sync the structures of the database, rebuild the database, copy one to the other and I still can't use the Sync Wizard. Any ideas?

[peterlaursen]

What are the versions of the MySQL servers involved.

And what is the SQLyog version ?

You can read this:

http://www.webyog.com/faq/10_68_en.html

I remember getting the 'NULL mismatch' error occurs when trying to sync my local 5.0 with MySQL 4.0 at my webhost with (I think) SQLyog versions before 4.1. But the most recent SQLyog versions should display an error instead.

If the MySQL versions are 'two much different' for the sync tool, you may be able to use ODBC. Read at the bottom here http://www.databasejournal.com/features/my…cle.php/3550146 (chapter 'MySQL and MySQL').

[barryccampbell]

Thanks for responding. You're right mysql versions are quite different. 5.0.15 on my local machine vs. 3.23.49 on my remote host. I just upgraded, but I'm fairly certain that I did not have the problem using SQLyog 4.1. I upgraded to 4.2 then 5.0 and had the problem starting with them. I am certain I did not have the problem when using a later version of mysql 4. I am able to get my local db copied to the remote host, but the sync tool was so handy. Just curious if there was a workaround to make it work.

[peterlaursen]

Quote:

but I'm fairly certain that I did not have the problem using SQLyog 4.1. I upgraded to 4.2 then 5.0 and had the problem starting with them.

Sounds strange in my ears! With the most latest SQLyog builds SQLyog will refuse to even try. Before that we had those errors.

Maybe it would have worked with some datatypes. But I doubt it!

There has been no changes on the server side? You could not have been using 5.0.15 for very long! and 3.x and 4.0 will sync OK (actually 4.1 will too if there are no TIMESTAMPS and similar variable types).

[barryccampbell]

I have not been using mysql 5 for very long. I reinstalled everything about 3 weeks ago and started using the current version of mysql at that time. Before reinstall, I set up a duplicate db on another local machine, version 5. I was still using 4.1 on the current host. I sync'd the 2 db's using sqlyog 4.1. Dumped the entire system. Then synced the files back from the 2nd machine when I reinstalled mysql 5 on my newly clean system. That could be when my problems started, but I thought I had sync'd with Yahoo! at least once after reinstalling everything.

I appreciate the previous posts. You have shed light on my problem. I will read the articles and sync with the Yahoo! host the way it says. Maybe Yahoo! will upgrade soon, but I doubt it.

Thanks again.

[peterlaursen]

Quote:

Maybe Yahoo! will upgrade soon, but I doubt it.

I doubt too. Most ISP's seem to think that the basic functionality of 3.23 or 4.0 is what customers need. And for use with scripting languages such as PHP and personal webpages they are probably right!

[Author]

Posts