Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Database Synchronization Wizard: Definition mismatch for ‘bigint’ column
Tagged: datatypes, mariadb, MySQL, Sync
I’m trying to sync two identical databases, but the first one is hosted on mysql engine, the other one on mariadb.
On some tables I theses errors:
Definition mismatch for ‘bigint’ column
Definition mismatch for ‘int’ column
It seems that mysql and mariadb use not fully compatible datatypes and that is preventing SQLyog to sync data (even if data itself would be migrated without issues because are the same type).
Is there a way to force SLQyog to ignore that differences and sync anyway?
Or another type of workaround?