Wordpress, Update the count parameter for a taxonomy, after data migration. In this case, only specify the post type name, and the associated taxonomies will be updated.

update_taxonomy_count.sql

UPDATE wp_term_taxonomy tt
    SET count =
    (SELECT count(p.ID) FROM  wp_term_relationships tr
    LEFT JOIN wp_posts p
    ON (p.ID = tr.object_id AND p.post_type = 'post_type_name' AND p.post_status = 'publish')
    WHERE tr.term_taxonomy_id = tt.term_taxonomy_id
)