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

sync problem

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › sync problem

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • June 21, 2005 at 8:49 am #9063
      davobw
      Member

      i have two mysql servers running on two different computers. one is the main server and the other just serves as backup/development server.

      sync'ing the structure works fine either way, but data sync'ing doesn't work at all, except for when i empty all tables on the backup server and then sync from the main server.

      the stats that show up in the data sync wizard show the right row count for both dbs, but say 0 inserts.

      on other post in the forum said the primary key could be the problem, but i checked: all pks are numerical ids (defined as int(11)) and never are composed by two fields.

      i also checked the sja.log file. it says:

      Error No. 1054

      Unknown column ',' in 'field list'

      however i don't have a ',' column defined.

      i have some innodb tables, but both myisam and innodb tables fail to sync.

    • June 21, 2005 at 11:56 am #18206
      Ritesh
      Member

      Can you mail me a copy of your source and target database?

    • June 21, 2005 at 7:33 pm #18207
      peterlaursen
      Participant

      @davobW

      You might be interested in follwing this discussion:

      http://www.webyog.com/forums/index.php?act…E=02&f=6&t=1500

      I have run into some problems like yours …

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.