{"id":120,"date":"2017-10-17T07:05:30","date_gmt":"2017-10-17T07:05:30","guid":{"rendered":"https:\/\/www.websupporters.com\/support\/knowledgebase\/?post_type=ht_kb&amp;p=120"},"modified":"2017-10-17T07:05:30","modified_gmt":"2017-10-17T07:05:30","slug":"how-to-upload-or-restore-database-using-plesk-panel","status":"publish","type":"ht_kb","link":"https:\/\/www.websupporters.com\/support\/knowledgebase\/kb\/how-to-upload-or-restore-database-using-plesk-panel\/","title":{"rendered":"How to Upload or Restore Database using Plesk Panel?"},"content":{"rendered":"<ul>\n<li>In Plesk, database dumps are created in the SQL format and saved as ZIP archives. If you need to create a dump in another format or to set custom settings for a dump, use the native functionality of database management tools (phpMyAdmin, phpPgAdmin, or myLittleAdmin). For the instructions on how to perform import and export with database management tools, refer to the tools&#8217; built-in help sections.<\/li>\n<\/ul>\n<h2>To Upload or Restore Database using Plesk Panel?<\/h2>\n<ol>\n<li><a href=\"https:\/\/www.websupporters.com\/support\/knowledgebase\/knowledge-base\/login-plesk-control-panel\/\" target=\"_blank\" rel=\"noopener\">Login To Plesk control panel.<\/a><\/li>\n<li>Go to the\u00a0<strong>Databases.<br \/>\n<a href=\"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-content\/uploads\/2017\/10\/plesk-database1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-109\" src=\"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-content\/uploads\/2017\/10\/plesk-database1-300x153.jpg\" alt=\"\" width=\"300\" height=\"153\" \/><\/a><\/strong><\/li>\n<li>Locate the name of the database you wish to upload or restore the backup from your local machine.<br \/>\n<a href=\"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-content\/uploads\/2017\/10\/database-list.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-123\" src=\"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-content\/uploads\/2017\/10\/database-list-300x151.jpg\" alt=\"\" width=\"300\" height=\"151\" \/><\/a><\/li>\n<li>Then click on\u00a0<strong>Import Dump<\/strong>\u00a0in the database tools pane<br \/>\n<a href=\"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-content\/uploads\/2017\/10\/db-import-dump.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-124\" src=\"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-content\/uploads\/2017\/10\/db-import-dump-300x151.jpg\" alt=\"\" width=\"300\" height=\"151\" \/><\/a><\/li>\n<li class=\"procedurelistnumber\">To choose a dump from your local computer in select\u00a0<strong>Upload<\/strong>\u00a0and click\u00a0<strong>Browse<\/strong>. Then select a database backup file.<br \/>\n<a href=\"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-content\/uploads\/2017\/10\/Screen-Shot-2017-10-17-at-1.58.51-PM.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-125\" src=\"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-content\/uploads\/2017\/10\/Screen-Shot-2017-10-17-at-1.58.51-PM-300x234.jpg\" alt=\"\" width=\"300\" height=\"234\" \/><\/a><\/li>\n<li>you will see the success or failure message in the right side of the message box.<\/li>\n<\/ol>\n<pre>If you are restoring MSSQL database please use .bak file format to restore mssql database.\n\nIf you are restoring mysql database please use .sql file format to restore mysql database.<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>In Plesk, database dumps are created in the SQL format and saved as ZIP archives. If you need to create a dump in another format or to set custom settings for a dump, use the native functionality of database management tools (phpMyAdmin, phpPgAdmin, or myLittleAdmin). For the instructions on how&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[3],"ht-kb-tag":[],"class_list":["post-120","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-windows-hosting"],"_links":{"self":[{"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/120","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/comments?post=120"}],"version-history":[{"count":0,"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/ht-kb\/120\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/media?parent=120"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/ht-kb-category?post=120"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.websupporters.com\/support\/knowledgebase\/wp-json\/wp\/v2\/ht-kb-tag?post=120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}