{"id":3995,"date":"2025-09-23T11:30:00","date_gmt":"2025-09-23T10:30:00","guid":{"rendered":"https:\/\/www.4uhosting.co.uk\/articles\/knowledgebase\/export-a-database-from-phpmyadmin\/"},"modified":"2026-08-19T14:00:58","modified_gmt":"2026-08-19T13:00:58","slug":"export-a-database-from-phpmyadmin","status":"publish","type":"kb_article","link":"https:\/\/www.4uhosting.co.uk\/articles\/knowledgebase\/export-a-database-from-phpmyadmin\/","title":{"rendered":"Export a Database from phpMyAdmin"},"content":{"rendered":"<p>You can export a database from phpMyAdmin in cPanel. This creates a <code>.sql<\/code> file that can be downloaded to your computer.<\/p>\n<p>To export a database:<\/p>\n<ol>\n<li>Log in to the 4UHosting client area at https:\/\/clients.4uhosting.co.uk.<\/li>\n<li>Choose <strong>My Services<\/strong>.<\/li>\n<li>Find the hosting service and select <strong>Manage<\/strong>.<\/li>\n<li>Select <strong>Login to cPanel<\/strong> from the left side.<\/li>\n<li>Open <strong>phpMyAdmin<\/strong>.<\/li>\n<li>Select the database you want to export.<\/li>\n<li>Choose <strong>Export<\/strong> from the top menu.<\/li>\n<li>Select <strong>Quick<\/strong> for a standard export or <strong>Custom<\/strong> if you need more control.<\/li>\n<li>Make sure the format is set to <strong>SQL<\/strong>.<\/li>\n<li>Select <strong>Export<\/strong> or <strong>Go<\/strong> to download the file.<\/li>\n<\/ol>\n<p>For most normal backups, the quick SQL export is enough.<\/p>\n<p>If the database is very large, the export may take longer or fail in the browser. If that happens, contact support and we can advise on the best way to export it.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can export a database from phpMyAdmin in cPanel. This creates a .sql file that can be downloaded to your computer. To export a&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"template":"","kb_category":[19],"class_list":["post-3995","kb_article","type-kb_article","status-publish","hentry","kb_category-cpanel-databases"],"_links":{"self":[{"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_article\/3995","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_article"}],"about":[{"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/types\/kb_article"}],"author":[{"embeddable":true,"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":1,"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_article\/3995\/revisions"}],"predecessor-version":[{"id":4095,"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_article\/3995\/revisions\/4095"}],"wp:attachment":[{"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/media?parent=3995"}],"wp:term":[{"taxonomy":"kb_category","embeddable":true,"href":"https:\/\/www.4uhosting.co.uk\/articles\/wp-json\/wp\/v2\/kb_category?post=3995"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}