MySQL Update Category Count

Update Category Count after database transition in WordPress via SQL query

Run the following script in your WP database


UPDATE wp_term_taxonomy SET count = (
SELECT COUNT(*) FROM wp_term_relationships rel 
LEFT JOIN wp_posts po ON (po.ID = rel.object_id) 
WHERE 
rel.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id 
AND 
wp_term_taxonomy.taxonomy NOT IN ('link_category')
AND 
po.post_status IN ('publish')
)