{"id":45183,"date":"2024-07-01T13:14:59","date_gmt":"2024-07-01T13:14:59","guid":{"rendered":"https:\/\/accuweb.cloud\/resource\/?post_type=faq&p=45183"},"modified":"2026-02-18T12:03:18","modified_gmt":"2026-02-18T12:03:18","slug":"dump-import-export-to-mysql","status":"publish","type":"faq","link":"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql","title":{"rendered":"Import and Export Dump Files to MySQL\/MariaDB\/Percona"},"content":{"rendered":"

Import and Export Dump Files to MySQL\/MariaDB\/Percona<\/h2>\n

Dump Import<\/h2>\n

Step 1.<\/strong>\u00a0Use a MySQL client (e.g., MySQL<\/a> Workbench in your local system) to connect to the Remote Database.<\/p>\n

Step 2.<\/strong> Go to the Database tab and click the Connect to Database<\/strong> option.<\/p>\n

\"Connect<\/a><\/p>\n

Step 3.<\/strong> In the Connect to Database window, enter the IP address, port number, username, and password (sent to you via email when you created the environment) in the respective field.<\/p>\n

Step 4.<\/strong>\u00a0Then click the OK<\/strong> button to start a connection.<\/p>\n

\"Start<\/a><\/p>\n

Step 5.<\/strong>\u00a0In the Password field, enter the database user password you entered in the Connect to Database window. Then click on the OK<\/strong> button to proceed.<\/p>\n

\"Database<\/a><\/p>\n

Step 6.<\/strong>\u00a0Once the database connection is successfully established, you will get a new tab with the Mysql@Server IP address.<\/p>\n

Step 7.<\/strong>\u00a0Go to the Management section on the screen’s left side and click on the Data Import\/Restore<\/strong> option.<\/p>\n

\"Import\/Restore\"<\/a><\/p>\n

Step 8.<\/strong>\u00a0In the Data Import window, choose the Import from Self-Contained File<\/strong> option and select the SQL dump file you want to import from the three-dot option.<\/p>\n

Select the database where you want to restore or import the SQL dump file in the Default Target Schema.<\/p>\n

You can create a new database by clicking on the New<\/strong> option if the database is not created.<\/p>\n

\"Import<\/a><\/p>\n

Please ensure that the database user you used to access the Database server has database create permission. If the user doesn’t, you will receive an error message.<\/p>\n

After then click on the Start Import<\/strong> button to start the import process.<\/p>\n

Step 9.<\/strong>\u00a0You will get the Progress status in the Import Progress tab and once it is complete, then you will get a finished message (i.e Import of C:\\User\\stpwe\\Downloads\\autotrade_db.sql has finished).<\/p>\n

\"Import<\/a><\/p>\n

Step 10.<\/strong>\u00a0Return to the AccuWeb.Cloud dashboard, open MySQL (MariaDB<\/a>) in a browser, and sign in with the provided credentials.<\/p>\n

Select “accuweb_db<\/strong> database and click on it. You will see your imported dump.<\/p>\n

\"Imported<\/a><\/p>\n

Dump Export<\/h2>\n

Step 1.<\/strong>\u00a0Open the server instance in your MySQL client, select Data Export, and choose the database objects to export.<\/p>\n

Specify the directory path for the dump.<\/p>\n

\"Select<\/a><\/p>\n

Step 2.<\/strong>\u00a0The export process can take several minutes, depending on the data size. Once the export process is completed, you will get a message (i.e. Import of C:\\User\\stpwe\\OneDrive\\Documents\\dumps\\Dump20240626 has finished). The dump file will be in the specified directory.<\/p>\n

\"Data<\/a><\/p>\n

\t\t
\n\t\t\t
\n \n
\n
\n
\n \n \t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t <\/div>\n <\/div>\n <\/div>\n <\/section>\n \t\t<\/div>\n\t\t<\/div>\n
<\/div>\n","protected":false},"author":1,"featured_media":52879,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","class_list":["post-45183","faq","type-faq","status-publish","has-post-thumbnail","hentry","faq_topics-databases","faq_topics-dump-import-export","faq_topics-kb","faq_topics-mysql-mariadb-percona","faq_topics-product-documentation"],"yoast_head":"\nImport And Export Dump Files to MySQL\/MariaDB\/Percona Databases<\/title>\n<meta name=\"description\" content=\"Learn how to import\/export dump files to MySQL\/MariaDB\/Percona databases. Follow this guide for efficient data transfer with a MySQL client.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Import and Export Dump Files to MySQL\/MariaDB\/Percona\" \/>\n<meta property=\"og:description\" content=\"Learn how to import\/export dump files to MySQL\/MariaDB\/Percona databases. Follow this guide for efficient data transfer with a MySQL client.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql\" \/>\n<meta property=\"og:site_name\" content=\"AccuWeb Cloud\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-18T12:03:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql#article\",\"isPartOf\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql\"},\"author\":{\"name\":\"Jilesh Patadiya\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58\"},\"headline\":\"Import and Export Dump Files to MySQL\/MariaDB\/Percona\",\"datePublished\":\"2024-07-01T13:14:59+00:00\",\"dateModified\":\"2026-02-18T12:03:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql\"},\"wordCount\":410,\"publisher\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#organization\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql#primaryimage\"},\"thumbnailUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"inLanguage\":\"en-US\"},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql\",\"url\":\"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql\",\"name\":\"Import And Export Dump Files to MySQL\/MariaDB\/Percona Databases\",\"isPartOf\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql#primaryimage\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql#primaryimage\"},\"thumbnailUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"datePublished\":\"2024-07-01T13:14:59+00:00\",\"dateModified\":\"2026-02-18T12:03:18+00:00\",\"description\":\"Learn how to import\/export dump files to MySQL\/MariaDB\/Percona databases. Follow this guide for efficient data transfer with a MySQL client.\",\"breadcrumb\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql#primaryimage\",\"url\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"contentUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/accuweb.cloud\/resource\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import and Export Dump Files to MySQL\/MariaDB\/Percona\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#website\",\"url\":\"https:\/\/accuweb.cloud\/resource\/\",\"name\":\"AccuWeb Cloud\",\"description\":\"Cutting Edge Cloud Computing\",\"publisher\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/accuweb.cloud\/resource\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#organization\",\"name\":\"AccuWeb.Cloud\",\"url\":\"https:\/\/accuweb.cloud\/resource\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg\",\"contentUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg\",\"width\":156,\"height\":87,\"caption\":\"AccuWeb.Cloud\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58\",\"name\":\"Jilesh Patadiya\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g\",\"caption\":\"Jilesh Patadiya\"},\"description\":\"Jilesh Patadiya, the visionary Co-Founder and Chief Technology Officer (CTO) behind AccuWeb.Cloud. Founder & CTO at AccuWebHosting.com. He shares his web hosting insights on the AccuWeb.Cloud blog. He mostly writes on the latest web hosting trends, WordPress, storage technologies, and Windows and Linux hosting platforms.\",\"sameAs\":[\"https:\/\/accuweb.cloud\/resource\",\"https:\/\/www.facebook.com\/accuwebhosting\",\"https:\/\/www.instagram.com\/accuwebhosting\/\",\"https:\/\/www.linkedin.com\/company\/accuwebhosting\/\",\"https:\/\/x.com\/accuwebhosting\",\"https:\/\/www.youtube.com\/c\/Accuwebhosting\"],\"url\":\"https:\/\/accuweb.cloud\/resource\/author\/accuwebadmin\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Import And Export Dump Files to MySQL\/MariaDB\/Percona Databases","description":"Learn how to import\/export dump files to MySQL\/MariaDB\/Percona databases. Follow this guide for efficient data transfer with a MySQL client.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql","og_locale":"en_US","og_type":"article","og_title":"Import and Export Dump Files to MySQL\/MariaDB\/Percona","og_description":"Learn how to import\/export dump files to MySQL\/MariaDB\/Percona databases. Follow this guide for efficient data transfer with a MySQL client.","og_url":"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql","og_site_name":"AccuWeb Cloud","article_modified_time":"2026-02-18T12:03:18+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql#article","isPartOf":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql"},"author":{"name":"Jilesh Patadiya","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58"},"headline":"Import and Export Dump Files to MySQL\/MariaDB\/Percona","datePublished":"2024-07-01T13:14:59+00:00","dateModified":"2026-02-18T12:03:18+00:00","mainEntityOfPage":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql"},"wordCount":410,"publisher":{"@id":"https:\/\/accuweb.cloud\/resource\/#organization"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql#primaryimage"},"thumbnailUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","inLanguage":"en-US"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql","url":"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql","name":"Import And Export Dump Files to MySQL\/MariaDB\/Percona Databases","isPartOf":{"@id":"https:\/\/accuweb.cloud\/resource\/#website"},"primaryImageOfPage":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql#primaryimage"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql#primaryimage"},"thumbnailUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","datePublished":"2024-07-01T13:14:59+00:00","dateModified":"2026-02-18T12:03:18+00:00","description":"Learn how to import\/export dump files to MySQL\/MariaDB\/Percona databases. Follow this guide for efficient data transfer with a MySQL client.","breadcrumb":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql#primaryimage","url":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","contentUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/accuweb.cloud\/resource\/articles\/dump-import-export-to-mysql#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/accuweb.cloud\/resource\/"},{"@type":"ListItem","position":2,"name":"Import and Export Dump Files to MySQL\/MariaDB\/Percona"}]},{"@type":"WebSite","@id":"https:\/\/accuweb.cloud\/resource\/#website","url":"https:\/\/accuweb.cloud\/resource\/","name":"AccuWeb Cloud","description":"Cutting Edge Cloud Computing","publisher":{"@id":"https:\/\/accuweb.cloud\/resource\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/accuweb.cloud\/resource\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/accuweb.cloud\/resource\/#organization","name":"AccuWeb.Cloud","url":"https:\/\/accuweb.cloud\/resource\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/","url":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg","contentUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg","width":156,"height":87,"caption":"AccuWeb.Cloud"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58","name":"Jilesh Patadiya","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g","caption":"Jilesh Patadiya"},"description":"Jilesh Patadiya, the visionary Co-Founder and Chief Technology Officer (CTO) behind AccuWeb.Cloud. Founder & CTO at AccuWebHosting.com. He shares his web hosting insights on the AccuWeb.Cloud blog. He mostly writes on the latest web hosting trends, WordPress, storage technologies, and Windows and Linux hosting platforms.","sameAs":["https:\/\/accuweb.cloud\/resource","https:\/\/www.facebook.com\/accuwebhosting","https:\/\/www.instagram.com\/accuwebhosting\/","https:\/\/www.linkedin.com\/company\/accuwebhosting\/","https:\/\/x.com\/accuwebhosting","https:\/\/www.youtube.com\/c\/Accuwebhosting"],"url":"https:\/\/accuweb.cloud\/resource\/author\/accuwebadmin"}]}},"_links":{"self":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/45183","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq"}],"about":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/types\/faq"}],"author":[{"embeddable":true,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/comments?post=45183"}],"version-history":[{"count":6,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/45183\/revisions"}],"predecessor-version":[{"id":53081,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/45183\/revisions\/53081"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/media\/52879"}],"wp:attachment":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/media?parent=45183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}