Title: how to retrieve comments/pingbacks using sql backup
Last modified: August 19, 2016

---

# how to retrieve comments/pingbacks using sql backup

 *  [ejm](https://wordpress.org/support/users/llizard/)
 * (@llizard)
 * [16 years, 12 months ago](https://wordpress.org/support/topic/how-to-retrieve-commentspingbacks-using-sql-backup/)
 * It has come to my attention recently that pingbacks from one particular site 
   are not appearing and must have been placed (inadvertantly by me) on the comment
   blacklist. I don’t remember putting them there. They have been on the blacklist
   for some time and I cannot seem to locate them in the blacklist section of the
   plugin (Spam Karma) I use to get rid of unwanted comments/pingbacks.
 * I have, however, found the comments in my sql backup. I tried to do a cross-search
   in the Spam Karma black list table in phpMyAdmin. But to no avail. I don’t really
   understand phpMyAdmin OR the sql database at all.
 * This is what I see in the sql databse BEFORE the comment that has been deleted:
   ……………………………………….
   INSERT INTO wp_options (option_id, blog_id, option_name, option_can_override,
   option_type, option_value, option_width, option_height, option_description, option_admin_level,
   autoload) VALUES …………………………………………
 * Is there a way to retrieve these pingbacks by going into the tables at phpMyAdmin?
   If so, can someone kindly spell it out for me?
 * I hope this question made sense and look forward to any help that can be offered.(
   And please bear with me if I seem particularly obtuse. I only know enough about
   php to get myself into a world of trouble.)
 * Thank you.
 * E Morris
 * WinXP, Firefox 3.0.10, WP2.0.11 with all updated and working plugins, including
   Spam Karma 2.3 rc4.
 * This is a bump of the thread started here: [http://wordpress.org/support/topic/273615?replies=1](http://wordpress.org/support/topic/273615?replies=1)

The topic ‘how to retrieve comments/pingbacks using sql backup’ is closed to new
replies.

## Tags

 * [black list](https://wordpress.org/support/topic-tag/black-list/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [ejm](https://wordpress.org/support/users/llizard/)
 * Last activity: [16 years, 12 months ago](https://wordpress.org/support/topic/how-to-retrieve-commentspingbacks-using-sql-backup/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics