Following are the steps :::
=================
1) Check the database name from wp-config.php file.
2) Backup the database using the following command from shell.
=============================
From cPanel ==> mysqldump database_name > database_name.sql
From Plesk ==> mysqldump –opt -uadmin -p`cat /etc/psa/.psa.shadow` database_name > database_name.sql
=============================
3) Now, login to phpmyadmin and select the database_name.
4) In the database click on table wp_options .
5) In wp_options click on Sql tab .
6) Execute the following queries for finding out the current theme enabled for wordpress site.
****************************************
SELECT *
FROM wp_options
WHERE option_name = 'template'
OR option_name = 'stylesheet'
OR option_name = 'current_theme';
****************************************
7) Now, execute the following query for changing the theme for wordpress site.
****************************************
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';
****************************************
Insert default= theme name. For example if theme is twentyeleven, then query should be as below ::
****************************************
UPDATE wp_options SET option_value = 'twentyeleven' WHERE option_name = 'template';
UPDATE wp_options SET option_value = 'twentyeleven' WHERE option_name = 'stylesheet';
UPDATE wp_options SET option_value = 'twentyeleven' WHERE option_name = 'current_theme';
****************************************
For confirmation again execute the query::
****************************************
SELECT *
FROM wp_options
WHERE option_name = 'template'
OR option_name = 'stylesheet'
OR option_name = 'current_theme';
****************************************
You will get the following result somthing like as below in phpmyadmin ::
****************************************
current_theme twentyeleven yes
stylesheet twentyeleven yes
template twentyeleven yes
****************************************
ENJOY..........
Nathan S.
=================
1) Check the database name from wp-config.php file.
2) Backup the database using the following command from shell.
=============================
From cPanel ==> mysqldump database_name > database_name.sql
From Plesk ==> mysqldump –opt -uadmin -p`cat /etc/psa/.psa.shadow` database_name > database_name.sql
=============================
3) Now, login to phpmyadmin and select the database_name.
4) In the database click on table wp_options .
5) In wp_options click on Sql tab .
6) Execute the following queries for finding out the current theme enabled for wordpress site.
****************************************
SELECT *
FROM wp_options
WHERE option_name = 'template'
OR option_name = 'stylesheet'
OR option_name = 'current_theme';
****************************************
7) Now, execute the following query for changing the theme for wordpress site.
****************************************
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';
****************************************
Insert default= theme name. For example if theme is twentyeleven, then query should be as below ::
****************************************
UPDATE wp_options SET option_value = 'twentyeleven' WHERE option_name = 'template';
UPDATE wp_options SET option_value = 'twentyeleven' WHERE option_name = 'stylesheet';
UPDATE wp_options SET option_value = 'twentyeleven' WHERE option_name = 'current_theme';
****************************************
For confirmation again execute the query::****************************************
SELECT *
FROM wp_options
WHERE option_name = 'template'
OR option_name = 'stylesheet'
OR option_name = 'current_theme';
****************************************
You will get the following result somthing like as below in phpmyadmin ::
****************************************
current_theme twentyeleven yes
stylesheet twentyeleven yes
template twentyeleven yes
****************************************
ENJOY..........
Nathan S.
Comment