Option 2
-
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!
-
Login to WordPress and go to Tools
-
Select Export
-
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)
-
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).
-
The above will ensure DB we are working with is clean.
-
Return to WP and go to Tools
-
Click Import
-
Upload the XML file you downloaded earlier
-
This will add all posts and comments made recently that were not captured by the copy of your downloaded DB.
-
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
-
This method also assumes the user know how to use phpMyAdmin
-
Login to phpMyAdmin
-
Select the database for WordPress that is affected
-
Download the latest copy of your database
-
Once a copy is downloaded to your hard drive, click on the search tab
-
Copy paste “rss_f541b3abd05e7962fcab37737f40fad8″ into the search box
-
Select find: “at least one of the words”
-
Select Inside Tables: “Select All”
-
Click Go
-
Look at the results list, it will show all tables with the mention of the rss tag
-
Delete all tables
-
Visit your site and ensure it is working fine
-
Download another copy of the DB which you know is clean.
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!
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.