In this article I will show you how to disable trackbacks and pingbacks on your old WordPress pages and posts quickly using a simply MySQL query.
Before doing so you will want to make sure that you have disabled link notifications (pingbacks and trackbacks) for any future posts or pages using the WordPress backend. Simply visit the “Settings > Discussion” admin page and uncheck the “Allow link notifications from other blogs (pingbacks and trackbacks) on new posts” option.
As stated, this particular setting only works going forward, on “new posts and pages“. Now to remove trackbacks and pingbacks on our old posts and pages.
Using a tool such as phpMyAdmin, access your WordPress sites’ database. If you haven’t already done so, be sure to make a backup of your entire database.
Click on the “SQL” tab and insert the following command into the field (note, change the table prefix “wp_” to whatever you are using):
UPDATE wp_posts SET ping_status= “closed”;
Then press the “Go” button down at the bottom right of the panel (see image below).
I welcome your thoughts, questions or suggestions on my article on removing existing trackbacks and pingbacks on old pages and posts.
Let me know if you found any errors within my article or if I may further assist you by answering any additional questions you may have.