{"id":36680,"date":"2014-09-22T07:32:15","date_gmt":"2014-09-22T11:32:15","guid":{"rendered":"http:\/\/www.templatemonster.com\/help\/?p=36680"},"modified":"2017-08-18T06:55:01","modified_gmt":"2017-08-18T10:55:01","slug":"no-database-selected-error-during-the-sql-file-import","status":"publish","type":"post","link":"https:\/\/www.templatemonster.com\/help\/no-database-selected-error-during-the-sql-file-import.html","title":{"rendered":"&#8220;No Database selected&#8221; error during the SQL file import"},"content":{"rendered":"<a href=\"http:\/\/www.youtube.com\/watch?v=NG31NCESoCE?width=1280&amp;height=720\" rel=\"prettyPhoto\">&#8220;No Database selected&#8221; error during the SQL file import<\/a>\r\n\r\n<p>This tutorial is going to show you how to fix &#8220;No Database selected&#8221; error that you can get after the SQL file import:<\/p>\r\n\r\n<a href=\"\/help\/wp-content\/uploads\/2014\/09\/no_database_selected1.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2014\/09\/no_database_selected1-300x127.jpg\" alt=\"no_database_selected1\" width=\"300\" height=\"127\" class=\"aligncenter size-medium wp-image-36681\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/09\/no_database_selected1-300x127.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/09\/no_database_selected1-150x63.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/09\/no_database_selected1.jpg 798w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\r\n<p>Obviously, the answer is in the error. You didn&#8217;t select any database before importing the SQL file. To fix this issue, you should perform the following steps:<\/p>\r\n<ol>\r\n  <li><p>In the phpMyAdmin panel in the left column you can see the list of available databases. Click the name of your database in that list:<\/p>\r\n  \r\n<a href=\"\/help\/wp-content\/uploads\/2014\/09\/no_database_selected2.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2014\/09\/no_database_selected2-300x168.jpg\" alt=\"no_database_selected2\" width=\"300\" height=\"168\" class=\"aligncenter size-medium wp-image-36682\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/09\/no_database_selected2-300x168.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/09\/no_database_selected2-150x84.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/09\/no_database_selected2.jpg 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n  \r\n  <\/li> \r\n  \r\n  <li><p>Now you should see your database name above the top menu of the phpMyAdmin panel. Click <strong>Import<\/strong> tab, then click <strong>Browse<\/strong> button and select the SQL file:<\/p>\r\n  \r\n <a href=\"\/help\/wp-content\/uploads\/2014\/09\/no_database_selected3.jpg\"><img loading=\"lazy\" src=\"\/help\/wp-content\/uploads\/2014\/09\/no_database_selected3-300x168.jpg\" alt=\"no_database_selected3\" width=\"300\" height=\"168\" class=\"aligncenter size-medium wp-image-36683\" srcset=\"https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/09\/no_database_selected3-300x168.jpg 300w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/09\/no_database_selected3-150x84.jpg 150w, https:\/\/www.templatemonster.com\/help\/wp-content\/uploads\/2014\/09\/no_database_selected3.jpg 1000w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a>\r\n\t\r\n  <\/li>\r\n \r\n  \r\n  <li><p> When you are done selecting the file, click <strong>GO<\/strong> button at the bottom of the page. You will see a message saying <strong>&quot;Import has been successfully finished, XXX queries executed&quot;<\/strong>.<\/p><\/li>\r\n  <li><p>Refresh the page and check your site. You can see the content on the site now.<\/p><\/li>\r\n<\/ol>\r\n<p>This is the end of the tutorial. Now you know how to fix &#8220;No Database selected&#8221; error. Feel free to check the detailed video tutorial below:<\/p>\r\n\r\n<a href=\"http:\/\/www.youtube.com\/watch?v=NG31NCESoCE?width=1280&amp;height=720\" rel=\"prettyPhoto\">&#8220;No Database selected&#8221; error during the SQL file import<\/a>\r\n\r\n<div class=\"inline-banner\">\r\n<a href=\"https:\/\/www.templatemonster.com\/cart.php?addOffer=587\">\r\n<img src=\"\/help\/files\/banners\/inline\/Banner-1-(500-x100).jpg\" \/>\r\n<\/a>\r\n<\/div>","protected":false},"excerpt":{"rendered":"<p>This tutorial is going to show you how to fix &#8220;No Database selected&#8221; error, that you can get after the SQL file import<\/p>\n","protected":false},"author":53,"featured_media":37635,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1019],"tags":[545,691,706,1403,1747,581],"_links":{"self":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/36680"}],"collection":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/users\/53"}],"replies":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/comments?post=36680"}],"version-history":[{"count":1,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/36680\/revisions"}],"predecessor-version":[{"id":82845,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/posts\/36680\/revisions\/82845"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media\/37635"}],"wp:attachment":[{"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/media?parent=36680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/categories?post=36680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.templatemonster.com\/help\/wp-json\/wp\/v2\/tags?post=36680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}