blog posts

hosting image
Change Theme WebHostingPeople

How to Change WordPress Theme by Editing Database?

< All Topics
You are here:
Print

Usually we alter a WordPress theme from our WordPress dashboard. Inn some circumstances, updating a plugin just isn’t appropriate with our present theme, so we have to swap our WordPress theme. In such conditions the one option to change the theme is manually from the database.

 

Steps to vary the WordPress theme inside phpMyAdmin

1) Log into cPanel.

2) Navigate to FileManager below ‘Information’ part.

Change Theme WebHostingPeople

 

3) Open ‘wp-config.php’ file and test the database identify.

Change Theme WebHostingPeople

 

4) Navigate to phpMyAdmin below ‘Databases’ and open the database for the WordPress web site.

5) Open wp-options desk from the database.

change WordPress theme WebHostingPeople

 

6) Find and open two rows known as the template and the stylesheet.

Change Theme WebHostingPeople

 

7) Open each template and the stylesheet. Then substitute the present theme by including the brand new theme in option_value.

Change Theme WebHostingPeople

 

8) Click on “Go” to allow modifications.

 

You’ll be able to change the WordPress theme by the terminal utilizing the next steps.

1)  Login to the server utilizing SSH command.

2) Add the theme within the theme folder.

3) Login to MySQL utilizing the beneath command.

# mysql -u root -p

4) Swap to web site database

5) Test the present theme which is utilized in WordPress web site utilizing the next command.

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

6) Now replace the WordPress theme utilizing the bellow command.

UPDATE wp_options SET option_value = ‘Themename’ WHERE option_name = ‘template’;

 

Should you want any additional assist please contact our assist division.

 

 

Knowledge Base Articles

Catagory