{"id":3426,"date":"2014-10-28T15:27:02","date_gmt":"2014-10-28T15:27:02","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2014\/10\/28\/phpmyadmin-export-table\/"},"modified":"2026-01-22T10:03:56","modified_gmt":"2026-01-22T15:03:56","slug":"phpmyadmin-export-table","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/","title":{"rendered":"How to Export a Table in phpMyAdmin"},"content":{"rendered":"<div class=\"imh-youtube-embed\">\n\t\t\t<iframe src=\"https:\/\/www.youtube.com\/embed\/90kDVwG1T1Q\" title=\"How to Export a Table in 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 Export a Table in phpMyAdmin\",\"description\":\"The video tutorial will walk you through the steps in exporting a table in the MySQL format.\",\"uploadDate\":\"2014-11-20\",\"thumbnailUrl\":\"https:\/\/img.youtube.com\/vi\/90kDVwG1T1Q\/hqdefault.jpg\"}<\/script>\n\t\t<\/div>\n\n\n\n<p><b>phpMyAdmin<\/b> is a powerful MySQL database client that has many capabilities. We will be showing one of its features \u2013 the export table option. Exporting a table means that you will make a copy of the table structures and its data. Caution should be taken whenever working with your database. <b><i>Make sure that you make a current <a href=\"\/support\/edu\/cpanel\/cpanel-backups\/#database\">backup of your database<\/a> before making any changes.<\/i> <\/b><\/p>\n\n\n\n<p class=\"alert alert-danger\">If you are exporting a table, you will be 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<h2 class=\"wp-block-heading\">How to Export a MySQL Database Table<\/h2>\n\n\n\n<ol class=\"wp-block-list article_list\">\n<li><a href=\"\/support\/edu\/cpanel\/how-to-log-into-cpanel\/\">Login to the cPanel<\/a><\/li>\n\n\n\n<li><a href=\"\/support\/images\/stories\/export-tables\/phpmyadmin-icon.png\" rel=\"lightbox-0\"><\/a><div style=\"clear: both;\"><a href=\"\/support\/images\/stories\/export-tables\/phpmyadmin-icon.png\" rel=\"lightbox-0\"><\/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><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><div style=\"clear: both;\">\u00a0<\/div> <\/div><\/li>\n\n\n\n<li><a href=\"\/support\/images\/stories\/export-tables\/expand-table-list.png\" rel=\"lightbox-0\"><\/a><div style=\"clear: both;\"><a href=\"\/support\/images\/stories\/export-tables\/expand-table-list.png\" rel=\"lightbox-0\"><\/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. Next, click on the plus sign (\u2018+\u2019) next to the database that contains the table the you wish to export.<\/p><br><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"302\" class=\"wp-image-90750\" style=\"width: 700px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/expand-table-list.jpg\" alt=\"\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/expand-table-list.jpg 800w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/expand-table-list-300x129.jpg 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/expand-table-list-768x331.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> <\/div><\/li>\n\n\n\n<li><a href=\"\/support\/images\/stories\/export-tables\/table-to-export.png\" rel=\"lightbox-0\"><\/a><div style=\"clear: both;\"><a href=\"\/support\/images\/stories\/export-tables\/table-to-export.png\" rel=\"lightbox-0\"><\/a><p>Click on the table name that you want to export.<\/p> <br><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"360\" class=\"wp-image-90752\" style=\"width: 700px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/table-to-export.jpg\" alt=\"\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/table-to-export.jpg 1337w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/table-to-export-300x154.jpg 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/table-to-export-1024x526.jpg 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/table-to-export-768x395.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> <\/div><\/li>\n\n\n\n<li><a href=\"\/support\/images\/stories\/export-tables\/export-function.png\" rel=\"lightbox-0\"><\/a><div style=\"clear: both;\"><a href=\"\/support\/images\/stories\/export-tables\/export-function.png\" rel=\"lightbox-0\"><\/a><p>In the top right of the phpMyAdmin interface, you should see a row of options starting with <b>Browse<\/b>. Click on <b>Export<\/b> in order to begin the export process.<\/p><br><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"363\" class=\"wp-image-90753\" style=\"width: 700px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/export-function.jpg\" alt=\"Click on Export\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/export-function.jpg 867w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/export-function-300x156.jpg 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/export-function-768x399.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> <\/div><\/li>\n\n\n\n<li><a href=\"\/support\/images\/stories\/export-tables\/export-options.png\" rel=\"lightbox-0\"><\/a><div style=\"clear: both;\"><a href=\"\/support\/images\/stories\/export-tables\/export-options.png\" rel=\"lightbox-0\"><\/a><p>In order to quickly export all of the data and the entire table structure, leave the <b>Quick<\/b> option selected. If you intend to be more selective, you would need to click on <b>Custom<\/b> in order to make changes to what will be exported. For the purposes of this tutorial, we will be exporting all of the table data, so please leave the option set to <b>Quick<\/b>.<\/p> <br><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"357\" class=\"wp-image-90754\" style=\"width: 700px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/export-options.jpg\" alt=\"Select export options\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/export-options.jpg 1054w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/export-options-300x153.jpg 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/export-options-1024x523.jpg 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/export-options-768x392.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> <\/div><\/li>\n\n\n\n<li><a href=\"\/support\/images\/stories\/export-tables\/file-format-export.png\" rel=\"lightbox-0\"><\/a><div style=\"clear: both;\"><a href=\"\/support\/images\/stories\/export-tables\/file-format-export.png\" rel=\"lightbox-0\"><\/a><p>The format of the exported file will be left as <b>SQL<\/b>. This can be changed by clicking on the drop-down arrow. 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 export.<\/p> \u00a0<img loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"344\" class=\"wp-image-90760\" style=\"width: 500px;\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/select-file-format-export.jpg\" alt=\"Select Format for export\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/select-file-format-export.jpg 622w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/select-file-format-export-300x206.jpg 300w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><br> <\/div><\/li>\n<\/ol>\n\n\n\n<p>Depending on the size of the table, it may take some time for the export to occur. Also, your web browser will determine how the file will be handled and\/or saved. For example, if the Downloads folder has been set in Firefox, then the exported file will be sent into that location. Other browsers may prompt you and ask for the location where the file should be saved. When the export completes, you will see the name of the file. Here\u2019s an example of the text that you may see:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> -- phpMyAdmin SQL Dump -- version 4.1.8 -- https:\/\/www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Oct 21, 2014 at 10:12 AM -- Server version: 5.6.17-log -- PHP Version: 5.4.23  SET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\"; SET time_zone = \"+00:00\";  -- Table structure for table `ps_access` --  CREATE TABLE IF NOT EXISTS `ps_access` (   `id_profile` int(10) unsigned NOT NULL,   `id_tab` int(10) unsigned NOT NULL,   `view` int(11) NOT NULL,   `add` int(11) NOT NULL,   `edit` int(11) NOT NULL,   `delete` int(11) NOT NULL,   PRIMARY KEY (`id_profile`,`id_tab`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;   INSERT INTO `ps_access` (`id_profile`, `id_tab`, `view`, `add`, `edit`, `delete`) VALUES (1, 0, 1, 1, 1, 1), (1, 1, 1, 1, 1, 1), (1, 2, 0, 0, 0, 0), (1, 3, 0, 0, 0, 0), (1, 4, 0, 0, 0, 0), (1, 5, 1, 1, 1, 1), (1, 6, 0, 0, 0, 0), (1, 7, 1, 1, 1, 1), (1, 8, 0, 0, 0, 0), (1, 9, 1, 1, 1, 1),<\/pre>\n\n\n\n<p>The file that is exported in <i>SQL format<\/i> is actually a text file and you can open it to see its contents. If you need to find anything in particular, use your favorite text editor and use the search options to find the text\/data that you require. Exported tables can be imported back into a database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>phpMyAdmin is a powerful MySQL database client that has many capabilities. We will be showing one of its features &#8211; the export table option. Exporting a table means that you will make a copy of the table structures and its data. Caution should be taken whenever working with your database. Make sure that you make<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-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-3426","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 Export a Table in phpMyAdmin | InMotion Hosting<\/title>\n<meta name=\"description\" content=\"If you need to quickly export data from a MySQL table, phpMyAdmin offers a quick option that allows you get a table and its structure. Follow the tutorial to learn how to use this interface.\" \/>\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-export-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Export a Table in phpMyAdmin | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"If you need to quickly export data from a MySQL table, phpMyAdmin offers a quick option that allows you get a table and its structure. Follow the tutorial to learn how to use this interface.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-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=\"2014-10-28T15:27:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-22T15:03:56+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=\"4 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-export-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/\"},\"author\":{\"name\":\"InMotion Hosting Contributor\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b\"},\"headline\":\"How to Export a Table in phpMyAdmin\",\"datePublished\":\"2014-10-28T15:27:02+00:00\",\"dateModified\":\"2026-01-22T15:03:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/\"},\"wordCount\":529,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-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-export-table\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/\",\"name\":\"How to Export a Table in phpMyAdmin | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon.jpg\",\"datePublished\":\"2014-10-28T15:27:02+00:00\",\"dateModified\":\"2026-01-22T15:03:56+00:00\",\"description\":\"If you need to quickly export data from a MySQL table, phpMyAdmin offers a quick option that allows you get a table and its structure. Follow the tutorial to learn how to use this interface.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-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-export-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Export a Table in 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 Export a Table in phpMyAdmin | InMotion Hosting","description":"If you need to quickly export data from a MySQL table, phpMyAdmin offers a quick option that allows you get a table and its structure. Follow the tutorial to learn how to use this interface.","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-export-table\/","og_locale":"en_US","og_type":"article","og_title":"How to Export a Table in phpMyAdmin | InMotion Hosting","og_description":"If you need to quickly export data from a MySQL table, phpMyAdmin offers a quick option that allows you get a table and its structure. Follow the tutorial to learn how to use this interface.","og_url":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2014-10-28T15:27:02+00:00","article_modified_time":"2026-01-22T15:03:56+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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/"},"author":{"name":"InMotion Hosting Contributor","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/8d626175dd3b70ee90a172bdb09a460b"},"headline":"How to Export a Table in phpMyAdmin","datePublished":"2014-10-28T15:27:02+00:00","dateModified":"2026-01-22T15:03:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/"},"wordCount":529,"commentCount":1,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-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-export-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/","url":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/","name":"How to Export a Table in phpMyAdmin | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2014\/10\/phpmyadmin-icon.jpg","datePublished":"2014-10-28T15:27:02+00:00","dateModified":"2026-01-22T15:03:56+00:00","description":"If you need to quickly export data from a MySQL table, phpMyAdmin offers a quick option that allows you get a table and its structure. Follow the tutorial to learn how to use this interface.","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/website\/phpmyadmin-export-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-export-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"How to Export a Table in 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\/3426","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=3426"}],"version-history":[{"count":8,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/3426\/revisions"}],"predecessor-version":[{"id":131483,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/3426\/revisions\/131483"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=3426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=3426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=3426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}