{"id":3427,"date":"2025-06-04T11:59:37","date_gmt":"2025-06-04T15:59:37","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2014\/10\/28\/phpmyadmin-import-table\/"},"modified":"2026-01-22T11:19:39","modified_gmt":"2026-01-22T16:19:39","slug":"phpmyadmin-import-table","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/","title":{"rendered":"How to Import a Table Using phpMyAdmin"},"content":{"rendered":"<div class=\"imh-youtube-embed\">\n\t\t\t<iframe src=\"https:\/\/www.youtube.com\/embed\/2dXyKo4_FNI\" title=\"How to Import a Table Using phpMyAdmin\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n\t\t\t<script type=\"application\/ld+json\">{\"@context\":\"https:\/\/schema.org\",\"@type\":\"VideoObject\",\"name\":\"How to Import a Table Using phpMyAdmin\",\"description\":\"This video tutorial will walk you through the steps of making a quick import with phpMyAdmin.\",\"uploadDate\":\"2014-11-20\",\"thumbnailUrl\":\"https:\/\/img.youtube.com\/vi\/2dXyKo4_FNI\/hqdefault.jpg\"}<\/script>\n\t\t<\/div>\n\n\n\n<p>So you want to import a table in your database with phpMyAdmin? <\/p>\n\n\n\n<p>phpMyAdmin is a useful database tool that can be used for a variety of MySQL database operations. The following tutorial covers the <em>import<\/em> feature. <em>Before you make any changes, be sure that you make a current <\/em><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/cpanel\/cpanel-backups\/#database\"><em>backup of your database<\/em><\/a><em> before making any changes.<\/em> Importing a table means that you will be bringing <a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/mariadb-adding-removing-indexes\/\">data<\/a> and\/or a table structure into the database. Note that this is different <a href=\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin\/import-database-using-phpmyadmin%20\">from importing a database<\/a>.<\/p>\n\n\n\n<p class=\"alert alert-danger\">Table imports through phpMyAdmin are limited to 50 MB. Tables larger than 50 MB will require that you <a href=\"\/support\/amp\/submitting-and-checking-on-status-of-tickets\/\">submit a ticket to technical support<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Supported File Formats<\/h3>\n\n\n\n<p>When importing a table into phpMyAdmin, selecting the right file format ensures proper data interpretation. Supported formats include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SQL (.sql) \u2013 This format is the best choice for preserving both table structure and data. It contains CREATE TABLE, INSERT, and other MySQL commands and is ideal for full database backups.<\/li>\n\n\n\n<li>CSV (.csv) \u2013 This format is used for spreadsheet-like data. It requires column mapping and is best for importing raw data (not structure).<\/li>\n\n\n\n<li>XML (.xml) \u2013 This format is Less common and is useful for structured data interchange. To successfully download a table, it must match phpMyAdmin\u2019s expected format.<\/li>\n\n\n\n<li>ODS\/JSON\/YAML \u2013 This format provides limited support depending on server configuration. It is used for specialized cases.<\/li>\n<\/ul>\n\n\n\n<p><strong>Tip:<\/strong> If you\u2019re unsure which format to use, SQL is generally the safest and most reliable option for preserving both structure and content of the table.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How to Import a MySQL Database Table<\/h2>\n\n\n\n<ol class=\"article_list wp-block-list\"><li><a href=\"\/support\/edu\/cpanel\/how-to-log-into-cpanel\/\">Login to the cPanel<\/a>.<\/li><li><a rel=\"lightbox-0\" href=\"\/support\/images\/stories\/import-tables\/phpmyadmin-icon.png\"><\/a><div style=\"clear: both;\"><a rel=\"lightbox-0\" href=\"\/support\/images\/stories\/import-tables\/phpmyadmin-icon.png\"><\/a><p>In the databases section, click on the icon labeled <b>phpMyAdmin<\/b>. This will launch the application and you will see the interface open with the list of databases that it can access listed on the left side.<\/p><br><img decoding=\"async\" width=\"574\" height=\"122\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon.jpg\" class=\"optimized-lcp-image\" alt=\"Click phpMyAdmin\" loading=\"eager\" fetchpriority=\"high\" sizes=\"(max-width: 768px) 100vw, 768px\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon.jpg 574w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon-300x64.jpg 300w\"><br><br> \u00a0 <\/div><\/li><li><a rel=\"lightbox-0\" href=\"\/support\/images\/stories\/import-tables\/import-db-list.png\"><\/a><div style=\"clear: both;\"><a rel=\"lightbox-0\" href=\"\/support\/images\/stories\/import-tables\/import-db-list.png\"><\/a><p>Click on the plus sign (\u2018+\u2019) next to the user name that appears in the column at left. This will expand the database list.<\/p><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"236\" class=\"wp-image-90767\" style=\"width: 700px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/import-db-list.jpg\" alt=\"import db list\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/import-db-list.jpg 875w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/import-db-list-300x101.jpg 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/import-db-list-768x259.jpg 768w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><br><br><\/div><\/li><li> Next, click on the name of the database that you wish to use for the import. Before you begin the file import, you will need to make sure that the same table does not already exist. <a style=\"font-size: revert;\" href=\"\/support\/website\/drop-table\/\">Delete or drop the table with phpMyAdmin<\/a><span style=\"font-size: revert; color: initial;\"> before you begin the import if you see that the table already exists. Make sure that you have backed up your database before you delete anything.<\/span> <br><br><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"173\" class=\"wp-image-90766\" style=\"width: 700px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/click-on-database.jpg\" alt=\"Click on Database\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/click-on-database.jpg 983w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/click-on-database-300x74.jpg 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/click-on-database-768x190.jpg 768w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><br><div style=\"clear: both;\">\u00a0<\/div> <\/li><li><a rel=\"lightbox-0\" href=\"\/support\/images\/stories\/import-tables\/import-menu.png\"><div style=\"clear: both;\"><p>You will see the database tables listed in the screen to the right. In the top right of the phpMyAdmin interface, you should see a row of options starting with <b>Browse<\/b>. Click on <b>Import<\/b> in order to begin the import process.<\/p><br><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"340\" class=\"wp-image-90768\" style=\"width: 700px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/select-import.jpg\" alt=\"Select Import\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/select-import.jpg 874w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/select-import-300x146.jpg 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/select-import-768x373.jpg 768w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><br><br> <div style=\"clear: both;\">\u00a0<\/div> <li><a rel=\"lightbox-0\" href=\"\/support\/images\/stories\/import-tables\/import-menu.png\"><div style=\"clear: both;\"><p>There are a number of options that you can select with import, but this tutorial deals with the default settings. Click on <b>Choose file<\/b> in order to choose the file that you wish to import. Please note again, that the file size limit for imports through phpMyAdmin is 50 MB.<\/p><br><img loading=\"lazy\" decoding=\"async\" width=\"1000\" height=\"508\" class=\"wp-image-90770\" style=\"width: 1000px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/choose-file-import.jpg\" alt=\"choose file to import\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/choose-file-import.jpg 1477w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/choose-file-import-300x152.jpg 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/choose-file-import-1024x520.jpg 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/choose-file-import-768x390.jpg 768w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><br><br> <div style=\"clear: both;\">\u00a0<\/div> <li><a rel=\"lightbox-0\" href=\"\/support\/images\/stories\/import-tables\/file-format.png\"><div style=\"clear: both;\"><p>The format of the file used for import should be <b>SQL<\/b>. This can be changed by clicking on the drop-down arrow for <b>Format<\/b>. However, to keep things simple, we are going to be using the default format of .SQL. Click on <b>Go<\/b> in order to start the import.<\/p><br><br><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"434\" class=\"wp-image-90771\" style=\"width: 700px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/select-import-file-format.jpg\" alt=\"Select Import file format\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/select-import-file-format.jpg 727w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/select-import-file-format-300x186.jpg 300w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><br> <div style=\"clear: both;\">\u00a0<\/div> \n\n\n\n<p>This completes our tutorial on importing tables into a database. Depending on the size of the table, it may take some time for the import to complete. When the import completes you will be able to look at the tables of the database and see the table that you have imported.<\/p>\n\n\n\n<figure class=\"wp-block-image is-style-default\"><a href=\"\/support\/images\/stories\/import-tables\/import-table-list.png\" rel=\"lightbox-0\"><img decoding=\"async\" src=\"\/support\/images\/stories\/import-tables\/import-table-list.png\" alt=\"Click click here to see the updated table list\"><\/a><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Import Options and Settings<\/h2>\n\n\n\n<p>When importing a table in phpMyAdmin, you\u2019ll find several options that help customize the process beyond just using the default SQL format.<\/p>\n\n\n\n<p>SQL (.sql) is the most commonly used format because it includes both the table structure and the data. However, phpMyAdmin also supports formats like CSV (.csv) for data-only imports, as well as XML and compressed files like .zip or .<a href=\"http:\/\/tar.gz\">tar.gz<\/a>.<\/p>\n\n\n\n<p><strong>Format:<\/strong> Choosing the correct format is important for a successful import and should match the type of file you\u2019re working with.<\/p>\n\n\n\n<p><strong>Character set:<\/strong> Another key setting is the character set. This determines how data is encoded, which affects how special characters and non-English text are handled. UTF-8 is recommended because it supports a wide range of characters and works well with most databases.<\/p>\n\n\n\n<p><strong>Foreign key checks and partial imports:<\/strong> phpMyAdmin also offers settings such as foreign key checks and partial imports. Foreign key checks help maintain relationships between tables. Disabling them temporarily can speed up large imports or avoid issues when related data isn\u2019t imported in the right order. Just be sure to re-enable them afterward to preserve data integrity.<\/p>\n\n\n\n<p>Partial import settings control how phpMyAdmin responds to errors. You can choose to continue on error\u2014logging failed rows but completing the import for valid data\u2014or rollback on error, which cancels the entire import if any problem occurs.<\/p>\n\n\n\n<p>\u201cContinue on error\u201d works well for large, non-critical data loads. In contrast, \u201crollback on error\u201d is better for critical imports where data consistency is essential.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">CSV Import Guide<\/h2>\n\n\n\n<p>Importing CSV files requires some specific configurations to ensure data integrity:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Delimiter Configuration:<\/strong> Specify the character that separates your fields in the CSV file, usually a comma (,) but sometimes semicolons (;) or tabs.<br><\/li>\n\n\n\n<li><strong>Handling Headers:<\/strong> Indicate whether your CSV file includes a header row with column names. If so, make sure to select the option so phpMyAdmin treats the first row correctly.<br><\/li>\n\n\n\n<li><strong>Excel Conversion:<\/strong> If your data is originally in Excel, export it as a CSV file before importing. Ensure the CSV file formatting matches the structure of the target table, including the correct number of columns and data types.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Troubleshooting Common Import Issues<\/h2>\n\n\n\n<p>Database imports can be tricky, but knowing how to tackle common errors makes the process smoother. Here are some common import issues and how to troubleshoot them:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">File Size Limitations and Workarounds<\/h3>\n\n\n\n<p>phpMyAdmin often has an upload limit (commonly 50MB). For larger files, consider splitting the SQL file into smaller parts or use SSH with command-line tools like mysql for importing.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Column Count Mismatch Errors<\/h3>\n\n\n\n<p>This occurs if the number of columns in your CSV file doesn\u2019t match the table\u2019s columns. Double-check your CSV file and the target table structure to ensure alignment before importing.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Character Set\/Collation Problems<\/h3>\n\n\n\n<p>If you notice strange characters or encoding issues after import, revisit the character set selection and ensure it matches the encoding of your source file and the database\u2019s collation settings.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Timeout or \u201cMySQL Server Has Gone Away\u201d Errors<\/h3>\n\n\n\n<p>These errors happen when the import process takes too long or the server disconnects. Increasing server settings like max_allowed_packet or importing via command line instead of phpMyAdmin can resolve these issues.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">SQL Syntax Errors<\/h3>\n\n\n\n<p>If your import fails with syntax errors, review the SQL file for mistakes such as missing semicolons, incorrect commands, or unsupported features. Cleaning up the SQL file or exporting again from the source often fixes these issues.<\/p>\n<\/div><\/a><\/li><\/div><\/a><\/li><\/div><\/a><\/li><\/ol>","protected":false},"excerpt":{"rendered":"<p>So you want to import a table in your database with phpMyAdmin? phpMyAdmin is a useful database tool that can be used for a variety of MySQL database operations. The following tutorial covers the import feature. Before you make any changes, be sure that you make a current backup of your database before making any<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/\"> Read More ><\/a><\/p>\n","protected":false},"author":7,"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":[4288],"tags":[],"class_list":["post-3427","post","type-post","status-publish","format-standard","hentry","category-website"],"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 Table Using phpMyAdmin | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"phpMyAdmin has many useful features including the option to import tables. The following tutorials steps you through how to use the import option.\" \/>\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\/website\/phpmyadmin-import-table\/\" \/>\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 Table Using phpMyAdmin | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"phpMyAdmin has many useful features including the option to import tables. The following tutorials steps you through how to use the import option.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/\" \/>\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=\"2025-06-04T15:59:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-22T16:19:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"574\" \/>\n\t<meta property=\"og:image:height\" content=\"122\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"InMotion Hosting Contributor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InMotion Hosting Contributor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/\"},\"author\":{\"name\":\"InMotion Hosting Contributor\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b\"},\"headline\":\"How to Import a Table Using phpMyAdmin\",\"datePublished\":\"2025-06-04T15:59:37+00:00\",\"dateModified\":\"2026-01-22T16:19:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/\"},\"wordCount\":1193,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon.jpg\",\"articleSection\":[\"Website\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/\",\"name\":\"How to Import a Table Using phpMyAdmin | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon.jpg\",\"datePublished\":\"2025-06-04T15:59:37+00:00\",\"dateModified\":\"2026-01-22T16:19:39+00:00\",\"description\":\"phpMyAdmin has many useful features including the option to import tables. The following tutorials steps you through how to use the import option.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon.jpg\",\"width\":574,\"height\":122,\"caption\":\"Click phpMyAdmin\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Import a Table 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\/8d626175dd3b70ee90a172bdb09a460b\",\"name\":\"InMotion Hosting Contributor\",\"description\":\"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/inmotion-hosting\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/arn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Import a Table Using phpMyAdmin | InMotion Hosting","description":"phpMyAdmin has many useful features including the option to import tables. The following tutorials steps you through how to use the import option.","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\/website\/phpmyadmin-import-table\/","og_locale":"en_US","og_type":"article","og_title":"How to Import a Table Using phpMyAdmin | InMotion Hosting","og_description":"phpMyAdmin has many useful features including the option to import tables. The following tutorials steps you through how to use the import option.","og_url":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2025-06-04T15:59:37+00:00","article_modified_time":"2026-01-22T16:19:39+00:00","og_image":[{"width":574,"height":122,"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon.jpg","type":"image\/jpeg"}],"author":"InMotion Hosting Contributor","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"InMotion Hosting Contributor","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/"},"author":{"name":"InMotion Hosting Contributor","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b"},"headline":"How to Import a Table Using phpMyAdmin","datePublished":"2025-06-04T15:59:37+00:00","dateModified":"2026-01-22T16:19:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/"},"wordCount":1193,"commentCount":2,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon.jpg","articleSection":["Website"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/","url":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/","name":"How to Import a Table Using phpMyAdmin | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon.jpg","datePublished":"2025-06-04T15:59:37+00:00","dateModified":"2026-01-22T16:19:39+00:00","description":"phpMyAdmin has many useful features including the option to import tables. The following tutorials steps you through how to use the import option.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon.jpg","width":574,"height":122,"caption":"Click phpMyAdmin"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-import-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Import a Table 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\/8d626175dd3b70ee90a172bdb09a460b","name":"InMotion Hosting Contributor","description":"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!","sameAs":["https:\/\/www.linkedin.com\/company\/inmotion-hosting\/","https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/arn\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"primary_category":{"id":4288,"name":"Website","slug":"website","link":"https:\/\/www.inmotionhosting.com\/support\/website\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/3427","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\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=3427"}],"version-history":[{"count":10,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/3427\/revisions"}],"predecessor-version":[{"id":131525,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/3427\/revisions\/131525"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=3427"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=3427"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=3427"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}