R-Ts NetWorks

Server the Best

Change Theme Without Login To WordPress Admin Area


Change Theme Without Login To WordPress Admin Area

Check the database name from wp-config.php file.

Backup the database using the following command from shell.

Cpanel

 mysqldump database_name > database_name.sql

Plesk

mysqldump –opt -uadmin -p`cat /etc/psa/.psa.shadow` database_name > database_name.sql

Now, login to phpmyadmin and select the database_name.

In the database click on table wp_options .

In wp_options click on Sql tab .

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’;

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’;

Replace default with theme name.

Check the theme again by running below command.

SELECT *
FROM wp_options
WHERE option_name = ‘template’
OR option_name = ‘stylesheet’
OR option_name = ‘current_theme’;

Advertisements

January 31, 2013 - Posted by | Wordpress

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: