Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Forums | Webyog

Tools to manage and monitor MySQL databases

Problem with conflicting MySQL versions

This topic is empty.

Viewing 4 reply threads

Author

Posts
- March 22, 2004 at 5:18 am #8373
  
  gunder
  Member
  
  Hi,
  
  I am getting the following error when try to sync my data:
  
  “Warning : Source and Target MySQL versions are not matching.
  
  Source : 3.23.46, Target : 4.0.16-nt.
  
  SJA may not work properly because of the difference in behaviour of concat_ws() across multiple MySQL versions.
  
  Error No. 1062
  
  Duplicate entry '16' for key 1″
  
  etc,
  
  None of the data is copied. Any ideas?
- March 22, 2004 at 5:34 am #15584
  
  Ritesh
  Member
  
  This error is caused due to the difference in MySQL versions.
- March 22, 2004 at 12:48 pm #15585
  
  gunder
  Member
  
  Ritesh wrote on Mar 22 2004, 05:34 AM:
  
  This error is caused due to the difference in MySQL versions.
  
  Do both server and client have to have IDENTICAL versions? My server is a UNIX box, so it won't run MYSQL-nt. Is there no solution? This seems to me that this is a severe limitation.
- March 22, 2004 at 2:40 pm #15586
  
  Ritesh
  Member
  
  Only the version of MySQL needs to be same. It doesnt matter if its UNIX or a WINDOWS build.
- March 22, 2004 at 3:03 pm #15587
  
  Shadow
  Member
  
  The problem is that some MySql versions contain incompatible changes. SQLyog uses the 4.0.x client library (there is a separate version for 4.1.1 and up) and one of your server is 3.x. SJA may work under these circumstances as well, but nothing can be guaranteed.
  
  About the error message: please check the key constraints, you might have different constraints on the two servers.
Author

Posts

Viewing 4 reply threads

You must be logged in to reply to this topic.