{"id":666,"date":"2025-12-26T08:22:38","date_gmt":"2025-12-26T07:22:38","guid":{"rendered":"https:\/\/mybox.com\/help\/?post_type=manual_kb&#038;p=666"},"modified":"2026-06-03T06:32:16","modified_gmt":"2026-06-03T04:32:16","slug":"how-to-restore-upload-a-database-from-a-sql-or-sql-gz-file-via-phpmyadmin","status":"publish","type":"manual_kb","link":"https:\/\/mybox.com\/help\/en\/knowledgebase\/how-to-restore-upload-a-database-from-a-sql-or-sql-gz-file-via-phpmyadmin\/","title":{"rendered":"How to restore\/upload a database from a .sql or .sql.gz file via phpMyAdmin?"},"content":{"rendered":"\n<div class=\"translation-block translation-block-merged\">\n<p class=\"wp-block-paragraph\">If you have a database backup in <code>.sql<\/code> or <code>.sql.gz<\/code> format, you can import it using phpMyAdmin.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before you begin, make sure you have:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Created a MySQL database<\/li>\n\n\n\n<li>Created a database user<\/li>\n\n\n\n<li>Assigned the user to the database with the appropriate permissions<\/li>\n<\/ul>\n\n\n\n<\/div>\n\n<div id=\"mybox-3357138760\" class=\"mybox-content mybox-entity-placement\"><div class=\"early-access-banner-inpost\">\r\n  <div class=\"banner-left-inpost\">\r\n    <div class=\"icon-box-inpost\">\r\n      <img decoding=\"async\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2026\/02\/square-info-icon.svg\" alt=\"Info\">\r\n    <\/div>\r\n    <div class=\"text-box-inpost\">\r\n      <span class=\"label-inpost\"><span class=\"translation-block translation-block-banner-text\">Early access<\/span><\/span>\r\n      <h4><span class=\"translation-block translation-block-banner-text\">Still need help?<\/span><\/h4>\r\n      <p><span class=\"translation-block translation-block-banner-text\">Contact our customer service team.<\/span><\/p>\r\n    <\/div>\r\n  <\/div>\r\n\r\n  <div class=\"banner-right-inpost\">\r\n    <a href=\"https:\/\/panel.mybox.com\/helpdesk2\/v\/list\/\" class=\"banner-button-inpost\"><span class=\"translation-block translation-block-banner-text\">Message us<\/span><\/a>\r\n  <\/div>\r\n<\/div><\/div>\n\n<div class=\"translation-block translation-block-merged\"><p class=\"wp-block-paragraph\">If you have not completed these steps yet, create the database and user first. <a href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/creating-a-database-and-a-database-user\/\">HERE<\/a> you can find a guide on how to do it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the myBox panel, in the <em><strong>&#8220;Databases&#8221;<\/strong><\/em> section at: <a href=\"https:\/\/panel.mybox.com\/databases\/v\/mysql-database-list\/\">https:\/\/panel.mybox.com\/databases\/v\/mysql-database-list\/<\/a> you will find the button: <em><strong>&#8220;phpMyAdmin&#8221;.<\/strong><\/em><br>Click on it. This will open a page in a new tab of your web browser with a login form directly to your database.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_86 ez-toc-wrap-left counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/how-to-restore-upload-a-database-from-a-sql-or-sql-gz-file-via-phpmyadmin\/#Whats_next\" >What&#8217;s next?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/mybox.com\/help\/en\/knowledgebase\/how-to-restore-upload-a-database-from-a-sql-or-sql-gz-file-via-phpmyadmin\/#Summary\" >Summary<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Whats_next\"><\/span>What&#8217;s next?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1.<\/strong> After logging in, select the name of your database from the left side of the screen and enter it.<\/p>\n\n\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"231\" height=\"127\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/phpadmin-wybor-bazy-1.jpg\" alt=\"\" class=\"wp-image-4338\" srcset=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/phpadmin-wybor-bazy-1.jpg 231w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/phpadmin-wybor-bazy-1-18x10.jpg 18w\" sizes=\"auto, (max-width: 231px) 100vw, 231px\" \/><\/figure>\n<\/div>\n\n<div class=\"translation-block translation-block-merged\">\n\n\n<p class=\"wp-block-paragraph\"><br><strong>2.<\/strong> At the top of the page, you will find the <em><strong>&#8220;Import&#8221;<\/strong><\/em> button.<\/p>\n\n\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"858\" height=\"68\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-373.png\" alt=\"\" class=\"wp-image-5487\" srcset=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-373.png 858w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-373-300x24.png 300w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-373-768x61.png 768w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-373-18x1.png 18w\" sizes=\"auto, (max-width: 858px) 100vw, 858px\" \/><\/figure>\n<\/div>\n\n<div class=\"translation-block translation-block-merged\">\n\n\n<p class=\"wp-block-paragraph\"><br><strong>3.<\/strong> After clicking on the <em><strong>&#8220;Import&#8221;<\/strong><\/em> button, a page with a form will appear, where you can indicate the .sql or .sql.gz file from the disk that you want to stay.<br>imported, and then in the vast majority of cases, without making changes to the other options, order the import by clicking the <em><strong>&#8220;Go&#8221;<\/strong><\/em> \/ <em><strong>&#8220;Import&#8221;<\/strong><\/em> button<\/p>\n\n\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"989\" height=\"778\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-374.png\" alt=\"\" class=\"wp-image-5488\" srcset=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-374.png 989w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-374-300x236.png 300w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-374-768x604.png 768w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/image-374-15x12.png 15w\" sizes=\"auto, (max-width: 989px) 100vw, 989px\" \/><\/figure>\n<\/div>\n\n<div class=\"translation-block translation-block-merged\">\n\n\n<p class=\"wp-block-paragraph\">Once the import is done correctly, after a while you should receive a message at the top of the page on a green background telling you how many queries have been executed.<\/p>\n\n\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"587\" height=\"45\" src=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/phpadmin-import-wykonano.jpg\" alt=\"\" class=\"wp-image-4341\" srcset=\"https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/phpadmin-import-wykonano.jpg 587w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/phpadmin-import-wykonano-300x23.jpg 300w, https:\/\/mybox.com\/help\/wp-content\/uploads\/2025\/12\/phpadmin-import-wykonano-18x1.jpg 18w\" sizes=\"auto, (max-width: 587px) 100vw, 587px\" \/><\/figure>\n<\/div>\n\n<div class=\"translation-block translation-block-merged\">\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Summary\"><\/span>Summary<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">phpMyAdmin allows you to import <code>.sql<\/code> and <code>.sql.gz<\/code> database backups directly through a web browser. After selecting the target database and uploading the backup file, phpMyAdmin executes the SQL statements and restores the database contents. The maximum import file size through phpMyAdmin is 32 MB.<\/p>\n<\/div>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"template":"","format":"standard","manualknowledgebasecat":[9,25],"manual_kb_tag":[1543,2663,2126,2664,2146,2665,2153,2666,2158,2667,2425,2668,2632,2669,185,2633,2670,214,2655,242,2656,283,2657,801,2658,968,2659,1014,2660,1108,2661,1518,2662],"class_list":["post-666","manual_kb","type-manual_kb","status-publish","format-standard","hentry","manualknowledgebasecat-databases","manualknowledgebasecat-hosting","manual_kb_tag-https","manual_kb_tag-import-file-limit","manual_kb_tag-restore-database","manual_kb_tag-sql-gzip-import","manual_kb_tag-phpmyadmin","manual_kb_tag-database-backup-restore","manual_kb_tag-mysql-database","manual_kb_tag-phpmyadmin-upload","manual_kb_tag-phpmyadmin-login","manual_kb_tag-import-database-via-phpmyadmin","manual_kb_tag-phpmyadmin-import","manual_kb_tag-upload-sql-file","manual_kb_tag-import-database","manual_kb_tag-sql-gz-file","manual_kb_tag-web-browser","manual_kb_tag-import-sql-file","manual_kb_tag-database-user","manual_kb_tag-create-database","manual_kb_tag-import-sql-gz-file","manual_kb_tag-mybox","manual_kb_tag-upload-database","manual_kb_tag-mybox-panel","manual_kb_tag-database-user-access","manual_kb_tag-mysql","manual_kb_tag-mybox-databases","manual_kb_tag-databases","manual_kb_tag-database-import-guide","manual_kb_tag-mybox-com","manual_kb_tag-phpmyadmin-tutorial","manual_kb_tag-database","manual_kb_tag-how-to-restore-database","manual_kb_tag-find","manual_kb_tag-large-file-import"],"_links":{"self":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/666","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb"}],"about":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/types\/manual_kb"}],"author":[{"embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":7,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/666\/revisions"}],"predecessor-version":[{"id":5490,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb\/666\/revisions\/5490"}],"wp:attachment":[{"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/media?parent=666"}],"wp:term":[{"taxonomy":"manualknowledgebasecat","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manualknowledgebasecat?post=666"},{"taxonomy":"manual_kb_tag","embeddable":true,"href":"https:\/\/mybox.com\/help\/en\/wp-json\/wp\/v2\/manual_kb_tag?post=666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}