{"id":18361,"date":"2026-09-29T21:06:27","date_gmt":"2026-09-29T18:06:27","guid":{"rendered":"https:\/\/www.hyyat.com\/knowledgebase\/import-export-mysql-database-phpmyadmin\/"},"modified":"2026-09-29T21:06:27","modified_gmt":"2026-09-29T18:06:27","password":"","slug":"import-export-mysql-database-phpmyadmin","status":"publish","type":"docs","link":"https:\/\/www.hyyat.com\/en\/knowledgebase\/import-export-mysql-database-phpmyadmin\/","title":{"rendered":"How to Import or Export a MySQL Database with phpMyAdmin"},"content":{"rendered":"
In short:<\/strong> To import: cPanel, then phpMyAdmin, choose the database, click Import, choose your .sql file and click Go. To export: choose the database or table, click Export and Go to download an SQL file. Create the database first before importing.<\/div>\n

Before importing, create the database and assign a user to it. See how to create a database and assign a user<\/a>.<\/p>\n

A) Import a database with phpMyAdmin<\/h2>\n

1.<\/strong> Log in to cPanel.<\/p>\n

2.<\/strong> In the Databases<\/strong> section click phpMyAdmin<\/strong>.<\/p>\n

\"phpMyAdmin<\/p>\n

3.<\/strong> phpMyAdmin opens. Select your database from the list on the left.<\/p>\n

\"Select<\/p>\n

4.<\/strong> Click Import<\/strong>.<\/p>\n

\"Import<\/p>\n

5.<\/strong> Choose the database file you want to upload.<\/p>\n

\"Choose<\/p>\n

6.<\/strong> Click Go<\/strong> to upload and import it.<\/p>\n

\"Import<\/p>\n

For very large files, compress the SQL file (.zip or .gz) before uploading, or ask our support to import it for you.<\/p>\n

B) Export a database with phpMyAdmin<\/h2>\n

1.<\/strong> Log in to cPanel and open phpMyAdmin<\/strong> from the Databases section.<\/p>\n

2.<\/strong> Select the database or table you want to export.<\/p>\n

\"Select<\/p>\n

3.<\/strong> Click Export<\/strong>.<\/p>\n

\"Export<\/p>\n

4.<\/strong> Click Go<\/strong> to download the SQL file.<\/p>\n

\"Download<\/p>\n

Note:<\/strong> the Custom<\/strong> export method lets you change many output settings, and the Format option lets you export as CSV, PDF, LaTeX and more. In most cases the default Quick method with SQL format is all you need.<\/p>\n

Related service:<\/strong> Hyyat Host shared hosting<\/a> includes cPanel, phpMyAdmin and unlimited databases on most plans, with 24\/7 support.<\/p>\n","protected":false},"excerpt":{"rendered":"

In short: To import: cPanel, then phpMyAdmin, choose the database, click Import, choose your .sql file and click Go. To export: choose the database or table, click Export and Go to download an SQL file. Create the database first before importing. Before importing, create the database and assign a user to it. See how to […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"_templately_pack_id":"","_templately_imported_at":"","_templately_source":"","_templately_import_session_id":"","footnotes":""},"doc_category":[2749],"doc_tag":[],"class_list":["post-18361","docs","type-docs","status-publish","hentry","doc_category-website-control-panel-cpanel"],"year_month":"2026-10","word_count":218,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"ahmed fathy","author_nicename":"ahmed-fathy","author_url":"https:\/\/www.hyyat.com\/en\/author\/ahmed-fathy\/"},"doc_category_info":[{"term_name":"Website control panel ( cpanel )","term_url":"https:\/\/www.hyyat.com\/en\/kb\/website-control-panel-cpanel\/"}],"doc_tag_info":[],"knowledge_base_info":[],"knowledge_base_slug":[],"_links":{"self":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs\/18361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/comments?post=18361"}],"version-history":[{"count":0,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/docs\/18361\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/media?parent=18361"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/doc_category?post=18361"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.hyyat.com\/en\/wp-json\/wp\/v2\/doc_tag?post=18361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}