WP Pro – Design, Development and Professional WordPress Hosting for Serious Bloggers - Just another WordPress weblog


Site Hacked: Site Name and Post Titles Changed via Database (Possible Fix)


Option 2

  1. This method assumes the user know how to use both phpMyAdmin as well as WP and that there exists a old copy of the DB that was downloaded prior to the hack!
  2. Login to WordPress and go to Tools
  3. Select Export
  4. Then select all authors and hit Download Export File, you will download a XML file created by WP, the name of the file will be something like, wordpress.2010-04-07.xml (wordpress.date.xml)
  5. Once downloaded to your hard drive, open phpMyAdmin on the server side and replace the corrupt database with a copy of the DB that is clean (although it will not have any of your recent posts/comments).
  6. The above will ensure DB we are working with is clean.
  7. Return to WP and go to Tools
  8. Click Import
  9. Upload the XML file you downloaded earlier
  10. This will add all posts and comments made recently that were not captured by the copy of your downloaded DB.
  11. Download a fresh copy of this DB which you know is clean.

Once the suspect file is deleted, DB replaced and posts added, make sure to rebuild your site map. Now wait and hope the Google and other bots crawl your site soon and reindex all posts!

Hope this helps.

- UPDATE 19:45 -

Option 3

  1. This method also assumes the user know how to use phpMyAdmin
  2. Login to phpMyAdmin
  3. Select the database for WordPress that is affected
  4. Download the latest copy of your database
  5. Once a copy is downloaded to your hard drive, click on the search tab
  6. Copy paste “rss_f541b3abd05e7962fcab37737f40fad8″ into the search box
  7. Select find: “at least one of the words”
  8. Select Inside Tables: “Select All”
  9. Click Go
  10. Look at the results list, it will show all tables with the mention of the rss tag
  11. Delete all tables
  12. Visit your site and ensure it is working fine
  13. Download another copy of the DB which you know is clean.

2 Responses to “Site Hacked: Site Name and Post Titles Changed via Database (Possible Fix)”

  1. I had no idea that people could do this!! Jeez, it’s a jungle out there. I will definitely be using that backup plugin now – thanks!

  2. I agree with this post as backups are certainly important. I’ve come across a situation similar to this that put our business back a whole week due to not properly backing up our servers. Take advantage of any automated tools – they’re worth it..even if you need a quick fix.


Leave a Response

Some Useful Info

Use SimpleCode while including codes.

The links from all comments have the no-follow tag to prevent spammers from gaming their way up into SERP. So please keep the comments clean, try not to use keywords as "Names" or post unnecessary links in the comments. Thank you for cooperating.



Copyright © WP Pro – Design, Development and Professional WordPress Hosting for Serious Bloggers - CSS | XHTML | Login | Return to Top ↑