Collation of the
#1 source db
is ‘latin1_german1_ci’, tables utf8mb4_unicode_520_ci, some(!) latin1_german1_ci, the example is from wp530_posts which has utf8mb4_unicode_ci, I have no idea why the collations are not unique
#2 target db
is ‘latin1_german1_ci’, tables all utf8mb4_unicode_520_ci