Exporting the trackback links from the wordpress comments queue?

[Fking]

I need a way to export all the trackback links from the wordpress comments queue.

But just the trackback ones, not the spammy comments with links in them.
Is there a plugin or something else for that?

[Fking]

Please?

[Istvan Horvath]

To export where?

Why don't you delete the spam first, so that you have only real feedback there...?

[Fking]

to a whatever list
just the urls of the sites sent trackbacks (linking to me)

[Istvan Horvath]

Post in the Programming Talk subforum and ask for somebody with MySQL query knowledge.

You will need a query that lists only the commen_type = trackback.

[Fking]

i can do that, but i was looking for an automated/ready solution

[Istvan Horvath]

Learn MySQL

go to your phpMyadmin > select the database > click the wp_comments on the left
Click "Search" on the top - and leave all the fields selected

In the field where it says: Add search conditions (body of the "where" clause): - type this:
comment_type = "trackback"
Hit the GO button next to it...

It should list only the TBs.

Then select all and Export.

[Fking]

Thanks
Seems that it can also be exported to excel and do whatever you want then
pretty cool!

[eBusinessChamp]

Hi Fking,

I've been looking for something similar, found a cool tool promoted by a fellow warrior:

Wordpress Indexing Plugin - Use With SEO Link Vine , UAW, AMA,FTS

The tool looks rock star, I will test it out next week.

Hope this helps