Image via Wikipedia

Hot To Manually Reset Your WordPress Theme From The Database Using phpMyAdmin

**Before you do any modifications on your database/WordPress install, MAKE SURE YOU HAVE AN UP-TO-DATE BACKUP of both your database and your site.

If you don’t know how to do this then stop reading NOW and find someone than can do it for you. Don’t contact me because you have broken your WordPress! You use the content of this post at your own risk.

Log into your phpMyAdmin interface, make sure you choose the database of your WordPress install and just run these 3 Update Queries one by one.

**You have do know the prefix that was used during the WordPress install. To find it, in phpMyAdmin, look at the start of each table name just before the underscore “_”. The default WorPress prefix is wp_ as in the following SQL queries. If there is another prefix, simply replace the wp_ by your prefix. So if your tables prefixes are wp4Fe_, you would have UPDATE wp4Fe_options …..

UPDATE wp_options SET option_value = "default" WHERE option_name = "template"
UPDATE wp_options SET option_value = "default" WHERE option_name = "stylesheet"
UPDATE wp_options SET option_value = "default" WHERE option_name = "current_theme"

If the queries have run successfully, your WordPress theme should be back to the default theme. If you did something wrong and your blog is not working anymore you can just restore the database with the backup you just did before starting the modifications. You did do a backup, Right?

I’m not giving more explanation because if you don’t know what to do from just this than you should not do it at all!

If you think I’m not being fare to you and you want more details, go to this blog (AT YOUR OWN RISK), it’s full of screen captures and a longer explanation.