Disable Trackbacks Pingbacks from Existing WordPress Post

Due to heavy spam, you may disable Trackbacks and Pingbacks but it will affect on future posts only.

To disable trackbacks and pingbacks form existing wordpress posts:

1. Take backup of your existing database
2. execute the following query:

UPDATE wp_posts SET ping_status='closed' WHERE post_status = 'publish' AND post_type = 'post';
UPDATE wp_posts SET ping_status='closed' WHERE post_status = 'publish' AND post_type = 'page';

Note:

Do it on your own risk. This post / site is not responsible for any damages.