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

eror in syncing : Definition mismatch for ….

forums forums SQLyog Sync tools, Migration, Scheduled Backup and Notifications eror in syncing : Definition mismatch for ….

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • #8461
      lujalu
      Member

      I try mysqlyog to sync our master and slave databases.

      Local: RedHat enterprise 3 / MySQL 3.23.58-max

      Remote : RedHat enterprise 3 /MySQL 3.23.58-max

      but i got eror on the synch process :

      Sync started at Tue Jun 8 16:45:32 2004

      Table SrcRows TgtRows Inserted Updated Deleted

      ========================= ======= ======= ======== ======= =======

      Definition mismatch for 'No_Anggota' column in '`Alamat`' table

      Definition mismatch for 'No_Anggota' column in '`Anggota`' table

      NULL definition mismatch for 'ID_Buku' column in '`Buku`' table

      Definition mismatch for 'No_Pengadaan' column in '`Detail_Pengadaan`' table

      Definition mismatch for 'No_Barcode' column in '`Eksemplar_Buku`' table

      Definition mismatch for 'No_Groups' column in '`Groups`' table

      Definition mismatch for 'No_Jabatan' column in '`Jabatan`' table

      Definition mismatch for 'No_Jenis_Buku' column in '`Jenis_Buku`' table

      Definition mismatch for 'Klasifikasi' column in '`Klasifikasi`' table

      Definition mismatch for 'Kota' column in '`Kota`' table

      Definition mismatch for 'No_Pengadaan' column in '`Log_Transfer`' table

      Definition mismatch for 'No_Uang' column in '`Mata_Uang`' table

      Definition mismatch for 'No_Peminjam' column in '`Peminjam`' table

      NULL definition mismatch for 'No_Penerbit' column in '`Penerbit`' table

      Definition mismatch for 'No_Pengadaan' column in '`Pengadaan`' table

      NULL definition mismatch for 'No_Pengarang' column in '`Pengarang`' table

      Definition mismatch for 'ID_Buku' column in '`Pengarang_Buku`' table

      Definition mismatch for 'No_Perolehan' column in '`Perolehan`' table

      Total time taken – 105 sec

      and i try with sja (linux) with the same result.

      pls help,does anyone know whats wrong with my database and my syncing process?what should i do.

      thanks before,

      Ila.

    • #15923
      Ritesh
      Member

      Can you give me the CREATE TABLE statement of the tables in both the databases?

    • #15924
      Shadow
      Member

      I would say that the definition of the synced tables are not exactly the same in the source and the target servers.

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