{"id":2842,"date":"2025-04-07T11:22:06","date_gmt":"2025-04-07T11:22:06","guid":{"rendered":"https:\/\/telahosting.com\/manual\/?p=2842"},"modified":"2026-02-02T10:21:08","modified_gmt":"2026-02-02T10:21:08","slug":"how-to-import-and-export-a-database-via-phpmyadmin","status":"publish","type":"post","link":"https:\/\/telahosting.com\/manual\/how-to-import-and-export-a-database-via-phpmyadmin\/","title":{"rendered":"How to Import and Export a Database via phpMyAdmin"},"content":{"rendered":"<p><iframe loading=\"lazy\" title=\"YouTube video player\" src=\"https:\/\/www.youtube.com\/embed\/7qqvg_ZcuT4?rel=0;si=vHHcMUgZTUp84HTi\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"display: inline-block; width: 0px; overflow: hidden; line-height: 0;\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><\/p>\n<p>In cPanel you can\u00a0import\u00a0and\u00a0export\u00a0databases using the\u00a0<b>phpMyAdmin<\/b> menu, which you can find in the\u00a0<b>Databases<\/b> section. Note that only databases of\u00a0<b>1 GB maximum<\/b>\u00a0can be imported\/exported in\u00a0<b>phpMyAdmin<\/b>. Larger databases should be imported\/exported via SSH. To do this, follow the instructions here or reach out to our technical department via <a href=\"https:\/\/my.telahosting.com\/submitticket.php\">ticket.<\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 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 ez-toc-toggle\" style=\"cursor:pointer\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/telahosting.com\/manual\/how-to-import-and-export-a-database-via-phpmyadmin\/#Database_Import\" >Database Import<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/telahosting.com\/manual\/how-to-import-and-export-a-database-via-phpmyadmin\/#Database_export\" >Database export<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/telahosting.com\/manual\/how-to-import-and-export-a-database-via-phpmyadmin\/#Access_denied_create_database_db_name_error_How_to_fix_it\" >Access denied create database db_name error. How to fix it?<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Database_Import\"><\/span><strong>Database Import<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>1. Log into your\u00a0<b>cPanel<\/b><\/p>\n<div>2. Navigate to the\u00a0<b>phpMyAdmin<\/b>\u00a0menu.<\/div>\n<div><\/div>\n<div>You can use our\u00a0<a href=\"https:\/\/telahosting.com\/manual\/how-to-log-in-to-your-cpanel-hosting-account\/\" target=\"_parent\">cPanel shortcuts<\/a> in the guide for quick access.<\/div>\n<div><\/div>\n<div><img data-dominant-color=\"fbfbfb\" data-has-transparency=\"false\" style=\"--dominant-color: #fbfbfb;\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-2848 size-medium not-transparent\" src=\"https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-03T145437.011-png-e1744024163429-800x272.avif\" alt=\"\" width=\"800\" height=\"272\" \/><\/div>\n<p>&nbsp;<\/p>\n<p>3. Select the\u00a0<b>database<\/b> that you need to import.<\/p>\n<p>4. In the upper bar, click the tab\u00a0<b>Import.<\/b><\/p>\n<p><img data-dominant-color=\"f1f2ef\" data-has-transparency=\"false\" style=\"--dominant-color: #f1f2ef;\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-2862 size-medium aligncenter not-transparent\" src=\"https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T110848.889-png-e1744024207864-800x382.avif\" alt=\"\" width=\"800\" height=\"382\" srcset=\"https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T110848.889-png-e1744024207864-800x382.avif 800w, https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T110848.889-png-e1744024207864-768x367.avif 768w, https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T110848.889-png-e1744024207864.avif 1366w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>5. Click <strong>Choose<\/strong> and locate the .sql file on your computer. Once done, click<strong> Import:<\/strong><\/p>\n<p><img data-dominant-color=\"f1efec\" data-has-transparency=\"false\" style=\"--dominant-color: #f1efec;\" loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-2863 aligncenter not-transparent\" src=\"https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T111818.617-711x400.avif\" alt=\"\" width=\"711\" height=\"400\" srcset=\"https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T111818.617-711x400.avif 711w, https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T111818.617-768x432.avif 768w, https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T111818.617-png.avif 1366w\" sizes=\"auto, (max-width: 711px) 100vw, 711px\" \/><\/p>\n<p>6. And you will see a notification that your database has been\u00a0<b>successfully imported.<\/b><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Database_export\"><\/span><strong>Database export<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>1. Log into your cPanel<br \/>\n2. Navigate to the phpMyAdmin menu:<\/p>\n<p><img data-dominant-color=\"fbfbfb\" data-has-transparency=\"false\" style=\"--dominant-color: #fbfbfb;\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-2848 size-medium aligncenter not-transparent\" src=\"https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-03T145437.011-png-e1744024297743-800x266.avif\" alt=\"\" width=\"800\" height=\"266\" srcset=\"https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-03T145437.011-png-e1744024297743-800x266.avif 800w, https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-03T145437.011-png-e1744024297743-768x256.avif 768w, https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-03T145437.011-png-e1744024297743.avif 1366w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>3. Select the\u00a0<b>database<\/b>\u00a0you need to export:<\/p>\n<p><img data-dominant-color=\"f5f5f4\" data-has-transparency=\"false\" style=\"--dominant-color: #f5f5f4;\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-2865 size-medium aligncenter not-transparent\" src=\"https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T112604.895-png-e1744024356345-800x209.avif\" alt=\"\" width=\"800\" height=\"209\" srcset=\"https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T112604.895-png-e1744024356345-800x209.avif 800w, https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T112604.895-png-e1744024356345-768x201.avif 768w, https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T112604.895-png-e1744024356345.avif 1366w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>4. Choose the tables that you need to export or click\u00a0<b>Check All<\/b>. Click\u00a0<b>Export<\/b>\u00a0to proceed:<\/p>\n<p><img data-dominant-color=\"ebebec\" data-has-transparency=\"false\" style=\"--dominant-color: #ebebec;\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-2866 size-medium aligncenter not-transparent\" src=\"https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T112911.012-png-e1744024401276-800x340.avif\" alt=\"\" width=\"800\" height=\"340\" srcset=\"https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T112911.012-png-e1744024401276-800x340.avif 800w, https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T112911.012-png-e1744024401276-768x326.avif 768w, https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T112911.012-png-e1744024401276.avif 1366w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/p>\n<p>5. Select the required file from the drop-down menu in\u00a0<b>Format<\/b> and click the <strong>Export <\/strong>button.<\/p>\n<p><strong><img data-dominant-color=\"f5f5f4\" data-has-transparency=\"false\" style=\"--dominant-color: #f5f5f4;\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-2867 size-medium aligncenter not-transparent\" src=\"https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T114757.128-png-e1744024439370-800x232.avif\" alt=\"\" width=\"800\" height=\"232\" srcset=\"https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T114757.128-png-e1744024439370-800x232.avif 800w, https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T114757.128-png-e1744024439370-768x223.avif 768w, https:\/\/telahosting.com\/manual\/wp-content\/uploads\/2025\/04\/telaHosting-Featured-image-template-2025-04-07T114757.128-png-e1744024439370.avif 1366w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Access_denied_create_database_db_name_error_How_to_fix_it\"><\/span><b>Access denied create database db_name error. <\/b><b>How to fix it?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you receive this error message, you can resolve the issue by following the steps below:<\/p>\n<p>1. Open the dump of your database using any text editor on your computer (for instance, Notepad or WordPad).<br \/>\n2. Find the line: CREATE DATABASE db_name (it can usually be found at the beginning) and remove it.<br \/>\n*db_name \u2013 your database name:<\/p>\n<p>3. Save it and import it using the instructions provided above.<\/p>\n<p>With this you can successfully export and import databases with phpMyAdmin. Happy Hosting.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\ufeff In cPanel you can\u00a0import\u00a0and\u00a0export\u00a0databases using the\u00a0phpMyAdmin menu, which you can find in the\u00a0Databases section. Note that only databases of\u00a01 GB maximum\u00a0can be imported\/exported in\u00a0phpMyAdmin. Larger databases should be imported\/exported via SSH. To do this, follow the instructions here or reach out to our technical department via ticket. Database Import 1. Log into your\u00a0cPanel 2&#8230;.<\/p>\n","protected":false},"author":10,"featured_media":2895,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[28],"tags":[51],"class_list":["post-2842","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-website-management","tag-database"],"_links":{"self":[{"href":"https:\/\/telahosting.com\/manual\/wp-json\/wp\/v2\/posts\/2842","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/telahosting.com\/manual\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/telahosting.com\/manual\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/telahosting.com\/manual\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/telahosting.com\/manual\/wp-json\/wp\/v2\/comments?post=2842"}],"version-history":[{"count":5,"href":"https:\/\/telahosting.com\/manual\/wp-json\/wp\/v2\/posts\/2842\/revisions"}],"predecessor-version":[{"id":3944,"href":"https:\/\/telahosting.com\/manual\/wp-json\/wp\/v2\/posts\/2842\/revisions\/3944"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/telahosting.com\/manual\/wp-json\/wp\/v2\/media\/2895"}],"wp:attachment":[{"href":"https:\/\/telahosting.com\/manual\/wp-json\/wp\/v2\/media?parent=2842"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/telahosting.com\/manual\/wp-json\/wp\/v2\/categories?post=2842"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/telahosting.com\/manual\/wp-json\/wp\/v2\/tags?post=2842"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}