{"id":17504,"date":"2019-06-05T18:16:34","date_gmt":"2019-06-05T22:16:34","guid":{"rendered":"https:\/\/www.boldgrid.com\/support\/?p=17504"},"modified":"2020-03-12T14:39:20","modified_gmt":"2020-03-12T18:39:20","slug":"switching-your-theme-via-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.boldgrid.com\/support\/wordpress-tutorials\/switching-your-theme-via-phpmyadmin\/","title":{"rendered":"Switching your Theme via phpMyAdmin"},"content":{"rendered":"<!DOCTYPE html PUBLIC \"-\/\/W3C\/\/DTD HTML 4.0 Transitional\/\/EN\" \"http:\/\/www.w3.org\/TR\/REC-html40\/loose.dtd\">\n<?xml encoding=\"utf-8\" ?><html><body><h1 id=\"switching-your-theme-via-phpmyadmin\">Switching your Theme via phpMyAdmin<\/h1>\n<p>If you need to switch your WordPress Theme and you do not have access to your WordPress Dashboard, and you are not able to <a href=\"\/support\/wordpress-tutorials\/switching-your-theme-via-wp-cli\/\">use WP-CLI to switch your theme<\/a>, you can use these instructions to switch your Theme using phpMyAdmin.<\/p>\n<ol>\n<li><strong>Log into phpMyAdmin,&nbsp;<\/strong>following your Web Host&rsquo;s instructions for doing so.<\/li>\n<li><strong>Make a backup of your database.<\/strong> Click on your database in the left-hand navigation pane, then click&nbsp;<strong>Export,&nbsp;<\/strong>choose&nbsp;<strong>SQL Format<\/strong><strong>,<\/strong> and click&nbsp;<strong>Go.<\/strong><\/li>\n<li><strong>Browse the wp_options table<\/strong> by clicking on it in the left-hand navigation pane.&nbsp;<em>Please note that your database may have a different prefix than&nbsp;<strong>wp_ .<\/strong> You can find your database prefix inside your wp-config.php file.<\/em><\/li>\n<li><strong>Update the two rows where option_name&rsquo;s are &ldquo;stylesheet&rdquo; and &ldquo;template.&rdquo;<\/strong> In this example, we&rsquo;re updating the stylesheet option to the theme TwentyNineteen, using all lower-case letters. <strong>It&rsquo;s important to update both rows.<\/strong><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-17505\" style=\"padding-top: 15px;\" src=\"https:\/\/www.boldgrid.com\/support\/wp-content\/uploads\/2019\/06\/Selection_695.png\" alt=\"Updating the stylesheet row to TwentyNineteen\" width=\"842\" height=\"403\" srcset=\"https:\/\/www.boldgrid.com\/support\/wp-content\/uploads\/2019\/06\/Selection_695.png 842w, https:\/\/www.boldgrid.com\/support\/wp-content\/uploads\/2019\/06\/Selection_695-300x144.png 300w, https:\/\/www.boldgrid.com\/support\/wp-content\/uploads\/2019\/06\/Selection_695-768x368.png 768w, https:\/\/www.boldgrid.com\/support\/wp-content\/uploads\/2019\/06\/Selection_695-250x120.png 250w, https:\/\/www.boldgrid.com\/support\/wp-content\/uploads\/2019\/06\/Selection_695-550x263.png 550w, https:\/\/www.boldgrid.com\/support\/wp-content\/uploads\/2019\/06\/Selection_695-800x383.png 800w, https:\/\/www.boldgrid.com\/support\/wp-content\/uploads\/2019\/06\/Selection_695-376x180.png 376w, https:\/\/www.boldgrid.com\/support\/wp-content\/uploads\/2019\/06\/Selection_695-627x300.png 627w\" sizes=\"auto, (max-width: 842px) 100vw, 842px\" \/><\/li>\n<\/ol>\n<p>Congratulations! You now know how to switch your WordPress Theme using phpMyAdmin.<\/p>\n<\/body><\/html>\n","protected":false},"excerpt":{"rendered":"<p>Switching your Theme via phpMyAdmin If you need to switch your WordPress Theme and you do not have access to your WordPress Dashboard, and you are not able to use WP-CLI to switch your theme, you can use these instructions to switch your Theme using phpMyAdmin. Log into phpMyAdmin,&nbsp;following your Web Host&rsquo;s instructions for doing [&hellip;]<\/p>\n","protected":false},"author":1294,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"bgseo_title":"","bgseo_description":"","bgseo_robots_index":"index","bgseo_robots_follow":"follow","footnotes":""},"categories":[151],"tags":[661],"class_list":["post-17504","post","type-post","status-publish","format-standard","hentry","category-wordpress-tutorials","tag-wordpress-tutorial","experience-level-advanced"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/posts\/17504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/users\/1294"}],"replies":[{"embeddable":true,"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/comments?post=17504"}],"version-history":[{"count":4,"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/posts\/17504\/revisions"}],"predecessor-version":[{"id":17544,"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/posts\/17504\/revisions\/17544"}],"wp:attachment":[{"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/media?parent=17504"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/categories?post=17504"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.boldgrid.com\/support\/wp-json\/wp\/v2\/tags?post=17504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}