{"id":3794,"date":"2022-01-04T05:36:37","date_gmt":"2022-01-04T05:36:37","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=3794"},"modified":"2022-01-04T05:36:37","modified_gmt":"2022-01-04T05:36:37","slug":"how-to-use-phpmyadmin-to-export-mysql-database-files","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/how-to-use-phpmyadmin-to-export-mysql-database-files\/","title":{"rendered":"How to Use phpMyAdmin to Export MySQL Database Files"},"content":{"rendered":"<p>The tutorial can illustrate a way to export a replica of your MySQL database backup file into your database server.<\/p>\n<p>So, let\u2019s move additional with the steps:<\/p>\n<p>1. Log in to\u00a0<strong>Plesk.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3795\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-1-194x300.png\" alt=\"database-file-1\" width=\"309\" height=\"477\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-1-194x300.png 194w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-1.png 309w\" sizes=\"auto, (max-width: 309px) 100vw, 309px\" \/><\/p>\n<p>2. Select\u00a0<strong>\u201cDatabases\u201d<\/strong>\u00a0section from the left-hand side of the screen.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3796\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-2-167x300.png\" alt=\"database-file-2\" width=\"239\" height=\"430\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-2-167x300.png 167w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-2.png 239w\" sizes=\"auto, (max-width: 239px) 100vw, 239px\" \/><\/p>\n<p>3. Click on\u00a0<strong>\u201cphpMyAdmin\u201d<\/strong>. You will enter into the\u00a0<strong>\u201cphpMyAdmin\u201d\u00a0<\/strong>page.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3797\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-3-300x171.png\" alt=\"database-file-3\" width=\"778\" height=\"444\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-3-300x171.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-3-768x438.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-3.png 778w\" sizes=\"auto, (max-width: 778px) 100vw, 778px\" \/><\/p>\n<p>4. Now, select the database from the left-hand side of the screen.<\/p>\n<p>5. A list of tables will appear. Select the\u00a0<strong>tables\u00a0<\/strong>from the list or you can also select all.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3798\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-4-300x172.png\" alt=\"database-file-4\" width=\"915\" height=\"526\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-4-300x172.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-4-768x441.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-4.png 915w\" sizes=\"auto, (max-width: 915px) 100vw, 915px\" \/><\/p>\n<p>6. Click on the\u00a0<strong>\u201cExport\u201d<\/strong>\u00a0button at the top of the screen.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3799\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-5-300x277.png\" alt=\"database-file-5\" width=\"558\" height=\"516\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-5-300x277.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-5.png 558w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><\/p>\n<p>7. Select the\u00a0<strong>export method<\/strong>\u2013\u00a0<strong>\u201cQuick\u201d<\/strong>\u00a0is selected by default, also select the\u00a0<strong>format<\/strong>.<\/p>\n<p>8. And press the\u00a0<strong>\u201cGo\u201d<\/strong>\u00a0button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3800\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-6-300x141.png\" alt=\"database-file-6\" width=\"1024\" height=\"480\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-6-300x141.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-6-768x360.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-6.png 1024w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>9. A\u00a0<strong>.sql<\/strong>\u00a0file will be downloaded to your PC as shown below. And then you can save it in the right place for your reference.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-3801\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2022\/01\/database-file-7.png\" alt=\"database-file-7\" width=\"238\" height=\"98\" \/><\/p>\n<p>Was this text helpful to you? If yes then you may check our web site for different articles too. And still, if you discover any reasonably issue contact our customer support team anytime you wish.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The tutorial can illustrate a way to export a replica of your MySQL database backup file into your database server. So, let\u2019s move additional with the steps: 1. Log in to\u00a0Plesk. 2. Select\u00a0\u201cDatabases\u201d\u00a0section from the left-hand side of the screen. 3. Click on\u00a0\u201cphpMyAdmin\u201d. You will enter into the\u00a0\u201cphpMyAdmin\u201d\u00a0page. 4. Now, select the database from the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24],"tags":[],"class_list":["post-3794","post","type-post","status-publish","format-standard","hentry","category-web-hosting"],"_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3794","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=3794"}],"version-history":[{"count":1,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3794\/revisions"}],"predecessor-version":[{"id":3802,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3794\/revisions\/3802"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=3794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=3794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=3794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}