UPDATE wp_posts set post_status=’publish’

edit: bide buraya bakarsın: https://www.r10.net/wordpress/1184917...ml-olarak.html