{"id":7608,"date":"2014-07-09T12:00:32","date_gmt":"2014-07-09T17:00:32","guid":{"rendered":"https:\/\/wpengine.com\/support\/importing-database\/"},"modified":"2026-05-25T09:34:59","modified_gmt":"2026-05-25T14:34:59","slug":"importing-database","status":"publish","type":"support","link":"https:\/\/wpengine.com\/support\/importing-database\/","title":{"rendered":"Import a WordPress Database"},"content":{"rendered":"<p>This article will cover how to import a WordPress\u00ae database file into your WP Engine environment; accessing phpMyAdmin through our User Portal (our version of the cPanel), clearing out the current default database, and importing your database file.<sup><a href=\"#legal-disclaimer\">1<\/a><\/sup> For this article you will need to already have exported and saved your database file as a .sql on your local computer. If you do not have a database file yet:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Follow this article to <a data-analytics-action-type=\"link\" data-analytics-link-location=\"Post Content\" data-analytics-link-type=\"internal\" href=\"https:\/\/wpengine.com\/support\/exporting-database\/\">export a database<\/a> from another host<\/li>\n\n\n\n<li>Or, check out this article to get your database file from a <a data-analytics-action-type=\"link\" data-analytics-link-location=\"Post Content\" data-analytics-link-type=\"internal\" href=\"https:\/\/wpengine.com\/support\/restore\/#toc-download-a-backup\">WP Engine backup<\/a><\/li>\n<\/ul>\n\n\n\n<section class=\"attention-block attention-block--info\" role=\"note\" data-analytics-track-visibility=\"yes\">\n\t<div class=\"attention-block__inner\">\n\t\t\t\t<div class=\"attention-block__icon\">\n\t\t\t<span class=\"screen-reader-text\">Information<\/span>\n\t\t\t<span aria-hidden=\"true\"><svg viewBox=\"0 2 24 24\" fill=\"none\">\n<path d=\"M12 11C12.5523 11 13 10.5523 13 10C13 9.44772 12.5523 9 12 9C11.4477 9 11 9.44772 11 10C11 10.5523 11.4477 11 12 11Z\" fill=\"currentColor\" \/>\n<path d=\"M12 12C12.5523 12 13 12.4477 13 13V18C13 18.5523 12.5523 19 12 19C11.4477 19 11 18.5523 11 18V14C10.4477 14 10 13.5523 10 13C10 12.4477 10.4477 12 11 12H12Z\" fill=\"currentColor\" \/>\n<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M12 3C5.92487 3 1 7.92487 1 14C1 20.0751 5.92487 25 12 25C18.0751 25 23 20.0751 23 14C23 7.92487 18.0751 3 12 3ZM3 14C3 9.02944 7.02944 5 12 5C16.9706 5 21 9.02944 21 14C21 18.9706 16.9706 23 12 23C7.02944 23 3 18.9706 3 14Z\" fill=\"currentColor\" \/>\n<\/svg>\n<\/span>\n\t\t<\/div>\n\t\t\t\t<div class=\"attention-block__content\">\n\t\t\t<div class=\"attention-block__message\">\n\n<h3 id=\"toc-note\" class=\"wp-block-heading\">Note<\/h3>\n\n\n\n<p>Prefer WP CLI? Try SSH Gateway to import your database instead. <a data-analytics-action-type=\"link\" data-analytics-link-location=\"Post Content\" data-analytics-link-type=\"internal\" href=\"https:\/\/wpengine.com\/support\/ssh-gateway\/\">Learn more here.<\/a><\/p>\n\n<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/section>\n\n\n\n\n\n<a name=\"accessdatabase\"><\/a>\n\n\n\n\n\n<h2 id=\"toc-access-phpmyadmin\" class=\"wp-block-heading\">Access phpMyAdmin<\/h2>\n\n\n\n<p>At WP Engine we use the phpMyAdmin utility to allow our customers to easily view and access their database directly from the browser. With one click you can securely login and access the database from the User Portal.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>From the <a data-analytics-action-type=\"link\" data-analytics-link-location=\"Post Content\" data-analytics-link-type=\"outbound\" href=\"https:\/\/my.wpengine.com\/sites\">Sites page<\/a>, select the environment <strong>name<\/strong> where the database will be imported<\/li>\n\n\n\n<li>Click <strong>phpMyAdmin<\/strong> at the top<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/wpengine.com\/wp-content\/uploads\/2020\/08\/open-phpmyadmin-1-1.png\" alt=\"\" class=\"wp-image-7100\"><\/figure>\n\n\n\n<a name=\"select\"><\/a>\n\n\n\n\n\n<h2 id=\"toc-select-database\" class=\"wp-block-heading\">Select Database<\/h2>\n\n\n\n<p>Ensure the correct database name is selected on the left. The database for the environment should be titled: <code>wp_<em>environmentname<\/em><\/code><\/p>\n\n\n\n<p>All Production, Staging, and Development <a data-analytics-action-type=\"link\" data-analytics-link-location=\"Post Content\" data-analytics-link-type=\"internal\" href=\"https:\/\/wpengine.com\/support\/environments\/\">environments<\/a> will use this naming convention.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/wpengine.com\/wp-content\/uploads\/2013\/12\/2-phpmyadmin-1.png\" alt=\"2-phpmyadmin\" class=\"wp-image-7101\"><\/figure>\n\n\n\n<a name=\"drop\"><\/a>\n\n\n\n\n\n<h2 id=\"toc-drop-database-tables\" class=\"wp-block-heading\">Drop Database Tables<\/h2>\n\n\n\n<p>Before importing your database you must create a clean slate and make room for your incoming database.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click on&nbsp;<strong>Check All<\/strong><\/li>\n\n\n\n<li>From the dropdown, select <strong>Drop<\/strong><\/li>\n\n\n\n<li>Click <strong>Go<\/strong><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/wpengine.com\/wp-content\/uploads\/2014\/01\/3-droptables-1.png\" alt=\"\" class=\"wp-image-7102\"><\/figure>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li>Another screen will display confirming the change, click <strong>Yes<\/strong><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/wpengine.com\/wp-content\/uploads\/2014\/01\/3-dropconfirm-1.png\" alt=\"\" class=\"wp-image-7103\"><\/figure>\n\n\n\n<p>Typically all tables should be dropped before attempting a database import. These steps may need to be performed several times, until no tables show and the interface reads \u201cNo tables found in database.\u201d<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter\"><img decoding=\"async\" src=\"https:\/\/wpengine.com\/wp-content\/uploads\/2019\/10\/import_database_notables-1.png\" alt=\"\" class=\"wp-image-7104\"><\/figure>\n\n\n\n<a name=\"import\"><\/a>\n\n\n\n\n\n<h2 id=\"toc-import-new-database\" class=\"wp-block-heading\">Import New Database<\/h2>\n\n\n\n<p>Now that the previous database has been cleared, we can import the new database file.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Click <strong>Import<\/strong> near the top<\/li>\n\n\n\n<li>Click on <strong>Choose File<\/strong><\/li>\n\n\n\n<li>Locate the new database file on your local system and select it\n<ul class=\"wp-block-list\">\n<li>In many cases this file is called something like <code>wp_environmentname.sql<\/code> <\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Click&nbsp;<strong>Go<\/strong><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><a data-analytics-action-type=\"link\" data-analytics-link-location=\"Post Content\" data-analytics-link-type=\"internal\" href=\"https:\/\/wpengine.com\/wp-content\/uploads\/2014\/01\/3-importsteps-1.png\"><img decoding=\"async\" src=\"https:\/\/wpengine.com\/wp-content\/uploads\/2014\/01\/3-importsteps-1.png\" alt=\"3-importsteps\" class=\"wp-image-7105\"><\/a><\/figure>\n\n\n\n<ol start=\"5\" class=\"wp-block-list\">\n<li>You will now see the new tables in the database, along with a report stating that the import has been successfully finished.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/wpengine.com\/wp-content\/uploads\/2014\/01\/3-importsuccess-1.png\" alt=\"\" class=\"wp-image-7106\"><\/figure>\n\n\n\n<p>If your site contains existing <a data-analytics-action-type=\"link\" data-analytics-link-location=\"Post Content\" data-analytics-link-type=\"internal\" href=\"https:\/\/wpengine.com\/support\/platform-settings\/\">revisions<\/a>, please contact our support team from your <a data-analytics-action-type=\"link\" data-analytics-link-location=\"Post Content\" data-analytics-link-type=\"outbound\" href=\"https:\/\/my.wpengine.com\/\">User Portal<\/a> prior to migrating or importing your content to avoid a loss of data. WP Engine disables revisions by default and old revisions may be removed automatically.<\/p>\n\n\n\n<section class=\"attention-block attention-block--info\" role=\"note\" data-analytics-track-visibility=\"yes\">\n\t<div class=\"attention-block__inner\">\n\t\t\t\t<div class=\"attention-block__icon\">\n\t\t\t<span class=\"screen-reader-text\">Information<\/span>\n\t\t\t<span aria-hidden=\"true\"><svg viewBox=\"0 2 24 24\" fill=\"none\">\n<path d=\"M12 11C12.5523 11 13 10.5523 13 10C13 9.44772 12.5523 9 12 9C11.4477 9 11 9.44772 11 10C11 10.5523 11.4477 11 12 11Z\" fill=\"currentColor\" \/>\n<path d=\"M12 12C12.5523 12 13 12.4477 13 13V18C13 18.5523 12.5523 19 12 19C11.4477 19 11 18.5523 11 18V14C10.4477 14 10 13.5523 10 13C10 12.4477 10.4477 12 11 12H12Z\" fill=\"currentColor\" \/>\n<path fill-rule=\"evenodd\" clip-rule=\"evenodd\" d=\"M12 3C5.92487 3 1 7.92487 1 14C1 20.0751 5.92487 25 12 25C18.0751 25 23 20.0751 23 14C23 7.92487 18.0751 3 12 3ZM3 14C3 9.02944 7.02944 5 12 5C16.9706 5 21 9.02944 21 14C21 18.9706 16.9706 23 12 23C7.02944 23 3 18.9706 3 14Z\" fill=\"currentColor\" \/>\n<\/svg>\n<\/span>\n\t\t<\/div>\n\t\t\t\t<div class=\"attention-block__content\">\n\t\t\t<div class=\"attention-block__message\">\n\n<h3 id=\"toc-note-1\" class=\"wp-block-heading\">Note<\/h3>\n\n\n\n<p>phpMyAdmin is limited to 50MB database imports. If you need to import a larger database, skip down to the <a href=\"#toc-failed-import\">Failed Import<\/a> section for further options.<\/p>\n\n<\/div>\n\t\t<\/div>\n\t<\/div>\n<\/section>\n\n\n\n<a name=\"prefix\"><\/a>\n\n\n\n\n\n<h2 id=\"toc-confirm-database-prefix\" class=\"wp-block-heading\">Confirm Database Prefix<\/h2>\n\n\n\n<p>Once you have successfully imported your database, you will need to check if your table prefixes are not default. A database using the default table prefix looks like the following. Note how each table begins with: <code>wp_<\/code><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/wpengine.com\/wp-content\/uploads\/2014\/05\/my-admin-1.jpg\" alt=\"\" class=\"wp-image-7107\"><\/figure>\n\n\n\n<p>If your tables do not start with <code>wp_<\/code>, please read <a data-analytics-action-type=\"link\" data-analytics-link-location=\"Post Content\" data-analytics-link-type=\"internal\" href=\"https:\/\/wpengine.com\/support\/changing-table-prefix\/\">How to change the table prefix<\/a> to ensure your site works properly on our system.<\/p>\n\n\n\n<p><span class=\"s2\">If your expected row count within phpMyAdmin doesn\u2019t match what\u2019s on display, it may be due to how the table\u2019s information is handled within MySQL.&nbsp;To get more information on the desired table, run the following commands from the SQL page within PHPMyAdmin after selecting a database:<\/span><\/p>\n\n\n\n<p><strong>View exact count of rows for a table:<\/strong><br><code>SELECT COUNT(*) FROM wp_posts;<\/code><br><strong>View information from PHPMyAdmin table status:<\/strong><br><code>SHOW TABLE STATUS;<\/code><br><a name=\"errors\"><\/a><\/p>\n\n\n\n\n\n<h2 id=\"toc-failed-import\" class=\"wp-block-heading\">Failed Import<\/h2>\n\n\n\n<p>If your database import failed, there could be a few different reasons for this.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Your database is too large, the maximum database import size is 50M. This limit is industry standard and cannot be increased. There are 3 alternatives:\n<ul class=\"wp-block-list\">\n<li>Upload the file to <code>_wpeprivate<\/code> using SFTP and <a data-analytics-action-type=\"link\" data-analytics-link-location=\"Post Content\" data-analytics-link-type=\"outbound\" href=\"https:\/\/my.wpengine.com\/support\">reach out to Support<\/a> to have it imported.<\/li>\n\n\n\n<li>Connect using <a data-analytics-action-type=\"link\" data-analytics-link-location=\"Post Content\" data-analytics-link-type=\"internal\" href=\"https:\/\/wpengine.com\/support\/ssh-gateway\/\">SSH Gateway<\/a> and import the database using <a data-analytics-action-type=\"link\" data-analytics-link-location=\"Post Content\" data-analytics-link-type=\"outbound\" rel=\"noopener noreferrer\" href=\"https:\/\/developer.wordpress.org\/cli\/commands\/db\/import\/\" target=\"_blank\">WP CLI.<\/a><\/li>\n\n\n\n<li>Export the database from the previous host as groups of fewer tables, rather than the whole database. <\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>There was an issue with the exported content.\n<ul class=\"wp-block-list\">\n<li>Attempt the export again, but this time with just a few tables. If this works continue importing tables a handful at a time until an issue is found. <\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>WP Engine runs daily maintenance processes that enforce limits on database options to preserve the stability of the site and the platform. Autoloaded rows (generally located within the <code>wp_options<\/code> table) are limited to 1MB of data per option. Database rows that are not automatically loaded are limited to 4MB of data per option.<\/li>\n<\/ol>\n\n\n\n<p>If your import failed, and you\u2019re unable to deduce why, please contact our support team at <a data-analytics-action-type=\"link\" data-analytics-link-location=\"Post Content\" data-analytics-link-type=\"outbound\" href=\"https:\/\/my.wpengine.com\/support\">WP Engine Support<\/a>. We are more than happy to help!<\/p>\n\n\n\n\n\n<p><strong>NEXT STEP: <a data-analytics-action-type=\"link\" data-analytics-link-location=\"Post Content\" data-analytics-link-type=\"internal\" href=\"https:\/\/wpengine.com\/support\/migration-process\/#toc-import-wp-content\">Import your wp-content directory<\/a><\/strong><\/p>","protected":false},"excerpt":{"rendered":"<p>Learn steps to import your database using phpMyAdmin in your WP Engine User Portal, as part of your manual migration process. <\/p>\n","protected":false},"featured_media":5937,"template":"","meta":{"_acf_changed":false,"mediapress_draft_name":"","_mediapress_is_draft_copy":false},"audience":[],"buyer-stage":[],"company-and-culture":[],"content-type":[],"location":[],"persona":[],"product":[84],"support-category":[130],"support-topic":[151,174],"topic":[],"use-cases":[],"class_list":["post-7608","support","type-support","status-publish","has-post-thumbnail","hentry","product-wp-migrate","support-category-onboarding-migrations","support-topic-database","support-topic-user-portal"],"acf":{"trending":false,"taxonomy_selector":{"":null,"taxonomy-audience":false,"taxonomy-buyer-stage":false,"taxonomy-company-and-culture":false,"taxonomy-content-type":false,"taxonomy-location":false,"taxonomy-persona":false,"taxonomy-product":[84],"taxonomy-support-topic":[151,174],"taxonomy-topic":false,"taxonomy-use-cases":false}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Import a WordPress Database | WP Engine Support<\/title>\n<meta name=\"description\" content=\"Learn steps to import your database using phpMyAdmin in your WP Engine User Portal, as part of your manual migration process.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wpengine.com\/support\/importing-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Import a WordPress Database | WP Engine Support\" \/>\n<meta property=\"og:description\" content=\"Learn steps to import your database using phpMyAdmin in your WP Engine User Portal, as part of your manual migration process.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wpengine.com\/support\/importing-database\/\" \/>\n<meta property=\"og:site_name\" content=\"WP Engine\u00ae\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/wpengine\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-05-25T14:34:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wpengine.com\/wp-content\/uploads\/2019\/12\/wp-engine-featured-image.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1\" \/>\n\t<meta property=\"og:image:height\" content=\"1\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@wpengine\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wpengine.com\\\/support\\\/importing-database\\\/\",\"url\":\"https:\\\/\\\/wpengine.com\\\/support\\\/importing-database\\\/\",\"name\":\"How to Import a WordPress Database | WP Engine Support\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wpengine.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/wpengine.com\\\/support\\\/importing-database\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/wpengine.com\\\/support\\\/importing-database\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wpengine.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/wp-engine-featured-image.png\",\"datePublished\":\"2014-07-09T17:00:32+00:00\",\"dateModified\":\"2026-05-25T14:34:59+00:00\",\"description\":\"Learn steps to import your database using phpMyAdmin in your WP Engine User Portal, as part of your manual migration process.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wpengine.com\\\/support\\\/importing-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wpengine.com\\\/support\\\/importing-database\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/wpengine.com\\\/support\\\/importing-database\\\/#primaryimage\",\"url\":\"https:\\\/\\\/wpengine.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/wp-engine-featured-image.png\",\"contentUrl\":\"https:\\\/\\\/wpengine.com\\\/wp-content\\\/uploads\\\/2019\\\/12\\\/wp-engine-featured-image.png\",\"caption\":\"WP Engine\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wpengine.com\\\/support\\\/importing-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/wpengine.com\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Import a WordPress Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wpengine.com\\\/#website\",\"url\":\"https:\\\/\\\/wpengine.com\\\/\",\"name\":\"WP Engine\u00ae\",\"description\":\"Managed Hosting for WordPress\",\"publisher\":{\"@id\":\"https:\\\/\\\/wpengine.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wpengine.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/wpengine.com\\\/#organization\",\"name\":\"WP Engine\",\"url\":\"https:\\\/\\\/wpengine.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/wpengine.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/wpengine.com\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/WPEngine_OGImage-1.webp\",\"contentUrl\":\"https:\\\/\\\/wpengine.com\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/WPEngine_OGImage-1.webp\",\"width\":1200,\"height\":630,\"caption\":\"WP Engine\"},\"image\":{\"@id\":\"https:\\\/\\\/wpengine.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/wpengine\\\/\",\"https:\\\/\\\/x.com\\\/wpengine\",\"https:\\\/\\\/www.instagram.com\\\/wpengine\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/wpengine\\\/\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCJeAEAxX69v24CUBZ0WBYSg\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Import a WordPress Database | WP Engine Support","description":"Learn steps to import your database using phpMyAdmin in your WP Engine User Portal, as part of your manual migration process.","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:\/\/wpengine.com\/support\/importing-database\/","og_locale":"en_US","og_type":"article","og_title":"How to Import a WordPress Database | WP Engine Support","og_description":"Learn steps to import your database using phpMyAdmin in your WP Engine User Portal, as part of your manual migration process.","og_url":"https:\/\/wpengine.com\/support\/importing-database\/","og_site_name":"WP Engine\u00ae","article_publisher":"https:\/\/www.facebook.com\/wpengine\/","article_modified_time":"2026-05-25T14:34:59+00:00","og_image":[{"url":"https:\/\/wpengine.com\/wp-content\/uploads\/2019\/12\/wp-engine-featured-image.png","width":1,"height":1,"type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@wpengine","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/wpengine.com\/support\/importing-database\/","url":"https:\/\/wpengine.com\/support\/importing-database\/","name":"How to Import a WordPress Database | WP Engine Support","isPartOf":{"@id":"https:\/\/wpengine.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wpengine.com\/support\/importing-database\/#primaryimage"},"image":{"@id":"https:\/\/wpengine.com\/support\/importing-database\/#primaryimage"},"thumbnailUrl":"https:\/\/wpengine.com\/wp-content\/uploads\/2019\/12\/wp-engine-featured-image.png","datePublished":"2014-07-09T17:00:32+00:00","dateModified":"2026-05-25T14:34:59+00:00","description":"Learn steps to import your database using phpMyAdmin in your WP Engine User Portal, as part of your manual migration process.","breadcrumb":{"@id":"https:\/\/wpengine.com\/support\/importing-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wpengine.com\/support\/importing-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wpengine.com\/support\/importing-database\/#primaryimage","url":"https:\/\/wpengine.com\/wp-content\/uploads\/2019\/12\/wp-engine-featured-image.png","contentUrl":"https:\/\/wpengine.com\/wp-content\/uploads\/2019\/12\/wp-engine-featured-image.png","caption":"WP Engine"},{"@type":"BreadcrumbList","@id":"https:\/\/wpengine.com\/support\/importing-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wpengine.com\/"},{"@type":"ListItem","position":2,"name":"Import a WordPress Database"}]},{"@type":"WebSite","@id":"https:\/\/wpengine.com\/#website","url":"https:\/\/wpengine.com\/","name":"WP Engine\u00ae","description":"Managed Hosting for WordPress","publisher":{"@id":"https:\/\/wpengine.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wpengine.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/wpengine.com\/#organization","name":"WP Engine","url":"https:\/\/wpengine.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wpengine.com\/#\/schema\/logo\/image\/","url":"https:\/\/wpengine.com\/wp-content\/uploads\/2025\/09\/WPEngine_OGImage-1.webp","contentUrl":"https:\/\/wpengine.com\/wp-content\/uploads\/2025\/09\/WPEngine_OGImage-1.webp","width":1200,"height":630,"caption":"WP Engine"},"image":{"@id":"https:\/\/wpengine.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/wpengine\/","https:\/\/x.com\/wpengine","https:\/\/www.instagram.com\/wpengine\/","https:\/\/www.linkedin.com\/company\/wpengine\/","https:\/\/www.youtube.com\/channel\/UCJeAEAxX69v24CUBZ0WBYSg"]}]}},"_links":{"self":[{"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/support\/7608","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/support"}],"about":[{"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/types\/support"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/media\/5937"}],"wp:attachment":[{"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/media?parent=7608"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/audience?post=7608"},{"taxonomy":"buyer-stage","embeddable":true,"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/buyer-stage?post=7608"},{"taxonomy":"company-and-culture","embeddable":true,"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/company-and-culture?post=7608"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/content-type?post=7608"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/location?post=7608"},{"taxonomy":"persona","embeddable":true,"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/persona?post=7608"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/product?post=7608"},{"taxonomy":"support-category","embeddable":true,"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/support-category?post=7608"},{"taxonomy":"support-topic","embeddable":true,"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/support-topic?post=7608"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/topic?post=7608"},{"taxonomy":"use-cases","embeddable":true,"href":"https:\/\/wpengine.com\/wp-json\/wp\/v2\/use-cases?post=7608"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}