{"id":329,"date":"2011-12-07T16:45:12","date_gmt":"2011-12-07T16:45:12","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2011\/12\/07\/import-database-using-phpmyadmin\/"},"modified":"2021-12-17T08:12:56","modified_gmt":"2021-12-17T13:12:56","slug":"import-database-using-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/","title":{"rendered":"How to Import a MySQL Database using phpMyAdmin"},"content":{"rendered":"<p>Are you planning to share a locally-developed database from your web server? Maybe you\u2019re <a href=\"\/support\/edu\/wordpress\/migrating-your-wordpress-database\/\">migrating a database for WordPress<\/a> or another content management system (CMS) for development purposes. Whatever the case, phpMyAdmin has a simple process for importing a database file after <a href=\"\/support\/edu\/cpanel\/create-mysql-database\/\">creating the database<\/a> in cPanel.<\/p>\n\n\n\n<p>In this tutorial, we will show you how to <strong>import a MySQL Database using phpMyAdmin in cPanel<\/strong>.<a name=\"prerequisites\"><\/a><\/p>\n\n\n\n<p class=\"alert alert-warning\">Advanced users can <a href=\"\/support\/website\/how-to-create-a-mysql-database-using-the-cpanel-api\/\">create<\/a> and <a href=\"\/support\/website\/import-database-through-shell\/\">import the database<\/a> using SSH.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"#prerequisites\">Prerequisites<\/a><\/li><li><a href=\"#how-to\">Import Database<\/a><\/li><li><a href=\"#troubleshooting\">Troubleshooting<\/a><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"prerequisites\">Prerequisites<\/h2>\n\n\n\n<p>We\u2019ll assume that you\u2019ve already <a href=\"\/support\/server\/databases\/export-database-using-phpmyadmin\/\">exported your database<\/a>, and it is either a .sql, zip, or tar.gz file.<\/p>\n\n\n\n<p>If needed, you can make changes to the file using a text editor \u2013 <i>e.g. <a href=\"\/support\/website\/ftp\/connect-ftp-notepad-plus\/\">Notepad++<\/a> and <a href=\"https:\/\/atom.io\/\">Atom.io<\/a><\/i> and file compression tools like <a href=\"\/support\/website\/compress-file\/\">7-Zip<\/a> and <a href=\"\/support\/edu\/software\/uncompress-rar-dr-unarchiver-mac\/\">The Unarchiver<\/a>.<\/p>\n\n\n\n<p>You should have already <a href=\"\/support\/edu\/cpanel\/create-mysql-database\/\">created the new database<\/a> that you\u2019re importing into as well.<\/p>\n\n\n\n<p><a name=\"how-to\"><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to\">Import Database<\/h2>\n\n\n\n<ol class=\"article_list wp-block-list\"><li><a href=\"\/support\/edu\/cpanel\/how-to-log-into-cpanel\/\">Log into cPanel<\/a>.<\/li><li>Under <i>Databases<\/i>, open phpMyAdmin by clicking the <b>phpMyAdmin<\/b> icon.<\/li><li>On the left, select the database that you will be working with.<\/li><li>Click <b>Import<\/b> in the top menu.<\/li><li>Under <b>File to Import<\/b>, click <b>Browse<\/b> and select the backup file you previously created (it will either be a .sql .zip or .tar.gz file).<br><img decoding=\"async\" width=\"1024\" height=\"553\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db-1024x553.png\" class=\"optimized-lcp-image\" alt=\"phpMyAdmin Import Database\" loading=\"eager\" fetchpriority=\"high\" sizes=\"(max-width: 768px) 100vw, 768px\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db-1024x553.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db-300x162.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db-768x415.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db.png 1666w\"><\/li><li>Click <b>Go<\/b> at the bottom right to import the database file.<\/li><li>When the database has been imported successfully, you should see a message at the top of the page similar to: <i>Import has been successfully finished, ## queries executed.<\/i><\/li><\/ol>\n\n\n\n<p>Congratulations, you have just imported a database!<\/p>\n\n\n\n<p><a name=\"troubleshooting\"><\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"troubleshooting\">Troubleshooting<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">#1044 \u2013 Access denied<\/h3>\n\n\n\n<p>If you get the following error when importing a database via PhpMyAdmin, you will need to edit the SQL file you\u2019re trying to import.<\/p>\n\n\n\n<p class=\"alert alert-warning\">CREATE SCHEMA IF NOT EXISTS `DataBaseName` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; MySQL said: Documentation #1044 \u2013 Access denied for user \u2018userna5\u2019@\u2019localhost\u2019 to database \u2018DatabaseName\u2019<\/p>\n\n\n\n<p>PhpMyAdmin does not allow you to CREATE databases due to security reasons. In order to get your SQL file to load you will need to remove the CREATE SCHEMA line at the beginning of your code. You can use our <a href=\"\/support\/server\/databases\/mysql-1044-access-denied-error-message\/\"><b>MySQL \u2013 1044 Access Denied Error Message<\/b> tutorial<\/a> and a text editor such as <a href=\"\/support\/website\/ftp\/connect-ftp-notepad-plus\/\">Notepad++<\/a> or <a href=\"https:\/\/atom.io\/\">Atom.io<\/a> to accomplish this.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"50mb\">50+ MB databases<\/h3>\n\n\n\n<p>The process for uploading databases over 50 MB differs depending on your InMotion Hosting plan.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Shared Servers<\/h4>\n\n\n\n<p>For databases over 50 MB, you can simply <a href=\"\/support\/website\/import-database-through-shell\/\">import the database via SSH<\/a>. Alternatively, you can <a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/installing-phpmyadmin-on-your-account\/\">install a phpMyAdmin instance<\/a> to import it to your server.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">VPS \/ Dedicated Servers<\/h4>\n\n\n\n<p>VPS and Dedicated server users with <a href=\"\/support\/server\/ssh\/root-access-faq\/\">root access<\/a> can increase the <i>max upload size<\/i> as needed in WebHost Manager(WHM) Tweak Settings section.<\/p>\n\n\n\n<p>Advanced users with <a href=\"\/support\/server\/ssh\/root-access-faq\/\">root access<\/a> can import a database larger than 50 MB by <a href=\"\/support\/server\/databases\/mysql-command-line\/\">logging into MySQL in SSH<\/a>. For more details on the <i>mysqlimport<\/i> command, go to <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/5.1\/en\/mysqlimport.html\" target=\"new\" rel=\"noopener noreferrer\">Dev.mysql.com\/doc<\/a>.<\/p>\n\n\n\n<p class=\"alert alert-info\"><b>Note:<\/b> If you need assistance with importing the process, you can <a href=\"\/support\/amp\/how-to-get-great-technical-support\/#submit-ticket\" target=\"new\" rel=\"noopener noreferrer\">email our technical support<\/a> a verified ticket request with the file and database name.<\/p>\n\n\n\n<p>We also have articles to help you <a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/\" target=\"new\" rel=\"noopener noreferrer\">manage your databases<\/a> and troubleshoot errors \u2013 <i>e.g. <a href=\"\/support\/server\/databases\/error-1064\/\" target=\"new\" rel=\"noopener noreferrer\">MySQL Error 1064: You have an error in your SQL syntax<\/a> <\/i>. If you have any issues upon importing your database, trying running a check and repair using <a href=\"\/support\/website\/check-repair-database\/\" target=\"new\" rel=\"noopener noreferrer\">cPanel<\/a> or <a href=\"\/support\/website\/check-and-repair-databases-in-cpanel\/\" target=\"new\" rel=\"noopener noreferrer\">phpMyAdmin<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Are you planning to share a locally-developed database from your web server? Maybe you\u2019re migrating a database for WordPress or another content management system (CMS) for development purposes. Whatever the case, phpMyAdmin has a simple process for importing a database file after creating the database in cPanel. In this tutorial, we will show you how<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/\"> Read More ><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4305],"tags":[],"class_list":["post-329","post","type-post","status-publish","format-standard","hentry","category-databases"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Import a MySQL Database using phpMyAdmin | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"In this tutorial, we will show you how to import a MySQL Database using phpMyAdmin.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/\" \/>\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 MySQL Database using phpMyAdmin | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, we will show you how to import a MySQL Database using phpMyAdmin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2011-12-07T16:45:12+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-17T13:12:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db.png\" \/>\n<meta name=\"author\" content=\"Brad Markle\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Brad Markle\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/\"},\"author\":{\"name\":\"Brad Markle\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/5ae05d1210b0ef63c437ccedce2799bf\"},\"headline\":\"How to Import a MySQL Database using phpMyAdmin\",\"datePublished\":\"2011-12-07T16:45:12+00:00\",\"dateModified\":\"2021-12-17T13:12:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/\"},\"wordCount\":540,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db.png\",\"articleSection\":[\"Working with Databases\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/\",\"name\":\"How to Import a MySQL Database using phpMyAdmin | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db.png\",\"datePublished\":\"2011-12-07T16:45:12+00:00\",\"dateModified\":\"2021-12-17T13:12:56+00:00\",\"description\":\"In this tutorial, we will show you how to import a MySQL Database using phpMyAdmin.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db.png\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db.png\",\"width\":1666,\"height\":900,\"caption\":\"phpMyAdmin Import Database\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Import a MySQL Database using phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/5ae05d1210b0ef63c437ccedce2799bf\",\"name\":\"Brad Markle\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/bradm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Import a MySQL Database using phpMyAdmin | InMotion Hosting","description":"In this tutorial, we will show you how to import a MySQL Database using phpMyAdmin.","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:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/","og_locale":"en_US","og_type":"article","og_title":"How to Import a MySQL Database using phpMyAdmin | InMotion Hosting","og_description":"In this tutorial, we will show you how to import a MySQL Database using phpMyAdmin.","og_url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2011-12-07T16:45:12+00:00","article_modified_time":"2021-12-17T13:12:56+00:00","og_image":[{"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db.png","type":"","width":"","height":""}],"author":"Brad Markle","twitter_card":"summary_large_image","twitter_creator":"@InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"Brad Markle","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/"},"author":{"name":"Brad Markle","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/5ae05d1210b0ef63c437ccedce2799bf"},"headline":"How to Import a MySQL Database using phpMyAdmin","datePublished":"2011-12-07T16:45:12+00:00","dateModified":"2021-12-17T13:12:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/"},"wordCount":540,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db.png","articleSection":["Working with Databases"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/","url":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/","name":"How to Import a MySQL Database using phpMyAdmin | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db.png","datePublished":"2011-12-07T16:45:12+00:00","dateModified":"2021-12-17T13:12:56+00:00","description":"In this tutorial, we will show you how to import a MySQL Database using phpMyAdmin.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db.png","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2019\/06\/phpmyadmin-import-db.png","width":1666,"height":900,"caption":"phpMyAdmin Import Database"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/import-database-using-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Import a MySQL Database using phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/5ae05d1210b0ef63c437ccedce2799bf","name":"Brad Markle","url":"https:\/\/www.inmotionhosting.com\/support\/author\/bradm\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":null,"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=329"}],"version-history":[{"count":11,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/329\/revisions"}],"predecessor-version":[{"id":92936,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/329\/revisions\/92936"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=329"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}