From the mysql command line client
To see all your trackback/pingbacks
SELECT * FROM wp_comments WHERE (comment_type = 'pingback' OR comment_type = 'trackback');
Narrow it down to a specific post
SELECT * FROM wp_comments WHERE (comment_type = 'pingback' OR comment_type = 'trackback') AND comment_post_ID = 2458;
Getting the Post ID from WordPress Admin Portal
To get the ID of a post hover over a post title in the Posts area of your WordPress Admin area. Depending on browser you will see post= in the URL popup somewhere on your screen
Delete specific trackback/pingbacks using comment_ID
-- Delete a specific tb/pb
DELETE FROM wp_comments WHERE comment_ID = 35405;
-- Delete all trackback/pingbacks from a post
DELETE FROM wp_comments WHERE comment_post_ID = 2458;
Determining if a custom table prefix is in use
Use SQL
use myqpdb;
show tables;
-- output will show the table names
Look in wp-config.php
// Change the prefix if you want to have multiple blogs in a single database.
$table_prefix = 'wp_abc123_'; // example: 'wp_' or 'b2' or 'mylogin_'
0 Comments