{"id":8357,"date":"2024-09-11T05:52:00","date_gmt":"2024-09-11T05:52:00","guid":{"rendered":"https:\/\/ubiq.co\/tech-blog\/?p=8357"},"modified":"2025-09-02T05:01:35","modified_gmt":"2025-09-02T05:01:35","slug":"how-to-mysqldump-only-specific-tables","status":"publish","type":"post","link":"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/","title":{"rendered":"How to MySQLDump Only Specific Tables"},"content":{"rendered":"\n<p>Often database administrators need to backup their data, or migrate it from one database to another. For this purpose, they need to dump their database to a .sql file which is later imported into the destination. Typically, administrators rely on MySQLdump utility for this purpose. However, sometimes they may need to export one or more specific tables from a single database, without actually dumping the entire database. They may also need to export these tables with or without data, as required. In this article, we will learn how to MySQLdump specific tables from your database.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#What_is_MySQLDump\" >What is MySQLDump<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#Why_MySQLDump_Specific_Tables\" >Why MySQLDump Specific Tables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#How_to_MySQLDump_Only_Specific_Tables\" >How to MySQLDump Only Specific Tables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#MySQLDump_Single_Table_With_Data\" >MySQLDump Single Table With Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#MySQLDump_Single_Table_Without_Data\" >MySQLDump Single Table Without Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#MySQLDump_Multiple_Tables_With_Data\" >MySQLDump Multiple Tables With Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#MySQLDump_Multiple_Tables_Without_Data\" >MySQLDump Multiple Tables Without Data<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#MySQLDump_Exclude_Specific_Tables\" >MySQLDump Exclude Specific Tables<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#Limit_Number_of_Records\" >Limit Number of Records<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#Conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"What_is_MySQLDump\"><\/span>What is MySQLDump<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>MySQLDump is a command line utility that ships with almost every MySQL client installation. It allows you to easily backup your databases and tables. It does so by examining your database and generating a set of SQL statements to re-generate its structure and data later. These SQL queries are stored in a .sql file. <\/p>\n\n\n\n<p>MySQLdump is commonly used to create backups of MySQL database, including its structure and data. It is also used to migrate databases from one server to another, by simply importing the generated .sql file in another database. MySQLDump can also be used to export one or more tables, instead of entire database. So it is good for cloning databases as well as tables.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Why_MySQLDump_Specific_Tables\"><\/span>Why MySQLDump Specific Tables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>There are several reasons why you may need to export specific tables in your database. Let us look at some of them.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Large database<\/strong> &#8211; If you have a large database with many tables, and you want to work with data of a few select tables, you can just dump them instead of your entire database. It also reduces the size of your data backup.<\/li>\n\n\n\n<li><strong>Testing Purposes<\/strong> &#8211; If you want to pass data between your development and production databases, you can easily do this by exporting a few tables from development system and importing them in your production server.<\/li>\n\n\n\n<li><strong>Quick Replication<\/strong> &#8211; It is easier to migrate database tables by dumping their schema, without data, and importing them in your destination database. This saves a lot of backup time.<\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"How_to_MySQLDump_Only_Specific_Tables\"><\/span>How to MySQLDump Only Specific Tables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Here is the general syntax of MySQLDump command.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump -u &lt;username&gt; -p &lt;database_name&gt; &gt; \/path\/to\/backup\/file<\/pre>\n\n\n\n<p>In the above command, we mention database username, name of database and full path to resultant .sql file. On running the above command, you will be prompted for a password. Enter it to complete the command. Here is a sample command to backup database test to file test.sql.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump -u test_user -p test &gt; \/home\/ubuntu\/test.sql<\/pre>\n\n\n\n<p>You can view all available options for this command by running <em>mysqldump<\/em> without anything else after it. Now let us learn how to use MySQLdump to backup specific tables in a database. In all the following commands, replace database_user with your database username.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MySQLDump_Single_Table_With_Data\"><\/span>MySQLDump Single Table With Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The most common use case is to dump a single table from a database, along with its data. You can do this by just mentioning the table name immediately after the database name in MySQLdump command as shown. Here is an example to dump only table1 from database data1.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump -u database_user data1 table1 &gt; \/home\/ubuntu\/table1.sql<\/pre>\n\n\n\n<p>After you run this command, you will find that the table1.sql file contains the SQL queries to regenerate the schema and data of table1.<\/p>\n\n\n\n<p>Alternatively, you can also use -t option before mentioning the table name in MySQLdump command.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump -u database_user data1 -t table1 &gt; \/home\/ubuntu\/table1.sql<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MySQLDump_Single_Table_Without_Data\"><\/span>MySQLDump Single Table Without Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Sometimes you may just need to dump the structure of a table without exporting any of its data. This is required if your table is very large. If you want to export a single table from a database without data, then use &#8211;no-data option as shown. Here is an example to dump only the structure of table table1 from database data1.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump -u database_user data1 table1 <strong>--no-data<\/strong> &gt; \/home\/ubuntu\/table1.sql<\/pre>\n\n\n\n<p>When you run the above command, it will dump only the SQL queries to recreate the table without any data in table1.sql file.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MySQLDump_Multiple_Tables_With_Data\"><\/span>MySQLDump Multiple Tables With Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Similarly, if you want to dump multiple tables from a database, mention their names one after the other, after the database name, in MySQLdump command. Here is an example to export only tables table1, table2, table3 from database data1.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump -u database_user data1 table1 table2 table3 &gt; \/home\/ubuntu\/tables.sql<\/pre>\n\n\n\n<p>After you run the above query, the tables.sql file will contain SQL statements to regenerate the schema and data of tables table1, table2, table3 only. If you are using -t option with MySQLdump command, you need to mention separate -t option before each table name.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump -u database_user data1 -t table1 -t table2 -t table3 &gt; \/home\/ubuntu\/tables.sql<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MySQLDump_Multiple_Tables_Without_Data\"><\/span>MySQLDump Multiple Tables Without Data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Dumping multiple tables without data can also be done using &#8211;no-data option as shown above. Here is an example to dump tables table1, table2, table3 schema without data.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump -u database_user data1 table1 table2 table3 --no-data &gt; \/home\/ubuntu\/tables.sql<\/pre>\n\n\n\n<p>After running the above command, MySQLdump will create a set of SQL statements to generate the structure of tables table1, table2, table3 only.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"MySQLDump_Exclude_Specific_Tables\"><\/span>MySQLDump Exclude Specific Tables<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This is an interesting use case. If your database has many tables and you want to dump all of them except a few then it can be tedious to mention all those table names after database name. Instead, you can use &#8211;ignore-table option followed by the table to be excluded from export. Here is an example to dump all tables from data1 database, excluding tables table1, table2, and table3.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump -u database_user data1 --ignore-table=table1 --ignore-table=table2 --ignore-table=table3 &gt; \/home\/ubuntu\/tables.sql<br><br>OR<br><br>mysqldump -u database_user data1 --ignore-table=data1.table1 --ignore-table=data1.table2 --ignore-table=data1.table3 &gt; \/home\/ubuntu\/tables.sql<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Limit_Number_of_Records\"><\/span>Limit Number of Records<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Another interesting use case is to be able to export only specific rows of specific tables. Typically, we use <a href=\"https:\/\/www.w3schools.com\/sql\/sql_where.asp\" target=\"_blank\" rel=\"noreferrer noopener\">WHERE clause<\/a> in SELECT statement to get only specific rows from tables.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">SELECT * from table_name WHERE condition<\/pre>\n\n\n\n<p>You can use the same WHERE condition even in MySQLdump command, using &#8211;where option. Here is an example to export only those rows from table1 in database data1, where created_at&gt;&#8217;2024-09-11&#8242;.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump -u database_user -p data1 table1 --where=\"created_at='2024-09-11'\" &gt; \/home\/ubuntu\/some_rows.sql<\/pre>\n\n\n\n<p>When you run the above statement, MySQLdump will store the SQL statements required to generate the schema of table1 and populate it with the rows where created_at&gt;&#8217;2024-09-11&#8242;. Please remember to use double quotes to specify the WHERE condition and single quotes inside double quotes.<\/p>\n\n\n\n<p>Here is another example to dump only 100 rows of table1 in database data1.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump -u database_user -p data1 table1 --where=\"1 LIMIT 100\" &gt; \/home\/ubuntu\/some_rows.sql<\/pre>\n\n\n\n<p>Please note:<\/p>\n\n\n\n<p>Sometimes, if your database is a high transaction one or a very large database with big tables, then it may get locked when you try to export one or more tables in it. In such cases, it is better to add &#8211;skip-lock-tables option. You can also use &#8211;single-transaction option to instruct MySQLdump to put everything into a single transaction. This way your data will not get locked while doing backups.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this article, we have learnt how to export specific database tables in MySQL. You can use it to dump data or structure of one or more database tables in MySQL.  It is very convenient to backup one or more tables in a database, instead of the entire database. It saves a lot of time and file size. We have also covered many common use cases faced by administrators while exporting their data. Depending on your requirement, you can use any of these commands.<\/p>\n\n\n\n<p>Need a reporting tool for MySQL?&nbsp;<a href=\"http:\/\/ubiq.co\/\">Ubiq<\/a>&nbsp;makes it easy to visualize data in minutes, and monitor in real-time dashboards.&nbsp;<a href=\"http:\/\/ubiq.co\/accounts\/register\">Try it<\/a>&nbsp;Today!<\/p>\n\n\n\n<p>Also read:<br><a href=\"https:\/\/ubiq.co\/tech-blog\/difference-between-innodb-vs-myisam\/\">Difference Between InnoDB vs MyISAM<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/single-quotes-double-quotes-and-backticks-in-mysql\/\">Single Quotes, Double Quotes and Backticks in MySQL<\/a><br><a href=\"https:\/\/ubiq.co\/tech-blog\/difference-between-inner-join-and-outer-join-in-sql\/\">Inner Join vs Outer Join In MySQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Often database administrators need to export one or more tables in a database. Learn how to MySQLdump specific tables in database.<\/p>\n","protected":false},"author":1,"featured_media":8359,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[324],"tags":[428],"class_list":["post-8357","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","tag-specific-tables"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to MySQLDump Only Specific Tables - Ubiq BI<\/title>\n<meta name=\"description\" content=\"Often database administrators need to export one or more tables in a database. Learn how to MySQLdump specific tables in database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to MySQLDump Only Specific Tables - Ubiq BI\" \/>\n<meta property=\"og:description\" content=\"Often database administrators need to export one or more tables in a database. Learn how to MySQLdump specific tables in database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"Ubiq BI\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ubiqbi\" \/>\n<meta property=\"article:published_time\" content=\"2024-09-11T05:52:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-02T05:01:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2024\/09\/mysqldump-specific-tables.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"461\" \/>\n\t<meta property=\"og:image:height\" content=\"346\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Sreeram Sreenivasan\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:site\" content=\"@UbiqBI\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sreeram Sreenivasan\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-mysqldump-only-specific-tables\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-mysqldump-only-specific-tables\\\/\"},\"author\":{\"name\":\"Sreeram Sreenivasan\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\"},\"headline\":\"How to MySQLDump Only Specific Tables\",\"datePublished\":\"2024-09-11T05:52:00+00:00\",\"dateModified\":\"2025-09-02T05:01:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-mysqldump-only-specific-tables\\\/\"},\"wordCount\":1205,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-mysqldump-only-specific-tables\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/mysqldump-specific-tables.webp?fit=461%2C346&ssl=1\",\"keywords\":[\"specific tables\"],\"articleSection\":[\"MySQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-mysqldump-only-specific-tables\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-mysqldump-only-specific-tables\\\/\",\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-mysqldump-only-specific-tables\\\/\",\"name\":\"How to MySQLDump Only Specific Tables - Ubiq BI\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-mysqldump-only-specific-tables\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-mysqldump-only-specific-tables\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/mysqldump-specific-tables.webp?fit=461%2C346&ssl=1\",\"datePublished\":\"2024-09-11T05:52:00+00:00\",\"dateModified\":\"2025-09-02T05:01:35+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\"},\"description\":\"Often database administrators need to export one or more tables in a database. Learn how to MySQLdump specific tables in database.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-mysqldump-only-specific-tables\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-mysqldump-only-specific-tables\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-mysqldump-only-specific-tables\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/mysqldump-specific-tables.webp?fit=461%2C346&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/ubiq.co\\\/tech-blog\\\/wp-content\\\/uploads\\\/2024\\\/09\\\/mysqldump-specific-tables.webp?fit=461%2C346&ssl=1\",\"width\":461,\"height\":346,\"caption\":\"mysqldump specific tables\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/how-to-mysqldump-only-specific-tables\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to MySQLDump Only Specific Tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#website\",\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/\",\"name\":\"Ubiq BI\",\"description\":\"Build dashboards &amp; reports in minutes\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/#\\\/schema\\\/person\\\/db98d49a766a3a111d8510935ab90abc\",\"name\":\"Sreeram Sreenivasan\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g\",\"caption\":\"Sreeram Sreenivasan\"},\"description\":\"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/sreeram-sreenivasan\\\/\"],\"url\":\"https:\\\/\\\/ubiq.co\\\/tech-blog\\\/author\\\/wordpress\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to MySQLDump Only Specific Tables - Ubiq BI","description":"Often database administrators need to export one or more tables in a database. Learn how to MySQLdump specific tables in database.","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:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/","og_locale":"en_US","og_type":"article","og_title":"How to MySQLDump Only Specific Tables - Ubiq BI","og_description":"Often database administrators need to export one or more tables in a database. Learn how to MySQLdump specific tables in database.","og_url":"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/","og_site_name":"Ubiq BI","article_publisher":"https:\/\/www.facebook.com\/ubiqbi","article_published_time":"2024-09-11T05:52:00+00:00","article_modified_time":"2025-09-02T05:01:35+00:00","og_image":[{"width":461,"height":346,"url":"https:\/\/ubiq.co\/tech-blog\/wp-content\/uploads\/2024\/09\/mysqldump-specific-tables.webp","type":"image\/webp"}],"author":"Sreeram Sreenivasan","twitter_card":"summary_large_image","twitter_creator":"@UbiqBI","twitter_site":"@UbiqBI","twitter_misc":{"Written by":"Sreeram Sreenivasan","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#article","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/"},"author":{"name":"Sreeram Sreenivasan","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"headline":"How to MySQLDump Only Specific Tables","datePublished":"2024-09-11T05:52:00+00:00","dateModified":"2025-09-02T05:01:35+00:00","mainEntityOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/"},"wordCount":1205,"commentCount":0,"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2024\/09\/mysqldump-specific-tables.webp?fit=461%2C346&ssl=1","keywords":["specific tables"],"articleSection":["MySQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/","url":"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/","name":"How to MySQLDump Only Specific Tables - Ubiq BI","isPartOf":{"@id":"https:\/\/ubiq.co\/tech-blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#primaryimage"},"image":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2024\/09\/mysqldump-specific-tables.webp?fit=461%2C346&ssl=1","datePublished":"2024-09-11T05:52:00+00:00","dateModified":"2025-09-02T05:01:35+00:00","author":{"@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc"},"description":"Often database administrators need to export one or more tables in a database. Learn how to MySQLdump specific tables in database.","breadcrumb":{"@id":"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#primaryimage","url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2024\/09\/mysqldump-specific-tables.webp?fit=461%2C346&ssl=1","contentUrl":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2024\/09\/mysqldump-specific-tables.webp?fit=461%2C346&ssl=1","width":461,"height":346,"caption":"mysqldump specific tables"},{"@type":"BreadcrumbList","@id":"https:\/\/ubiq.co\/tech-blog\/how-to-mysqldump-only-specific-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ubiq.co\/tech-blog\/"},{"@type":"ListItem","position":2,"name":"How to MySQLDump Only Specific Tables"}]},{"@type":"WebSite","@id":"https:\/\/ubiq.co\/tech-blog\/#website","url":"https:\/\/ubiq.co\/tech-blog\/","name":"Ubiq BI","description":"Build dashboards &amp; reports in minutes","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ubiq.co\/tech-blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/ubiq.co\/tech-blog\/#\/schema\/person\/db98d49a766a3a111d8510935ab90abc","name":"Sreeram Sreenivasan","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4b3127ed2d4bb8efb3fa0bbb52cf2efd4d0156c97fc05a503537c883e8279947?s=96&d=mm&r=g","caption":"Sreeram Sreenivasan"},"description":"Sreeram Sreenivasan is the Founder of Ubiq. He has helped many Fortune 500 companies in the areas of BI &amp; software development.","sameAs":["https:\/\/www.linkedin.com\/in\/sreeram-sreenivasan\/"],"url":"https:\/\/ubiq.co\/tech-blog\/author\/wordpress\/"}]}},"jetpack_featured_media_url":"https:\/\/i0.wp.com\/ubiq.co\/tech-blog\/wp-content\/uploads\/2024\/09\/mysqldump-specific-tables.webp?fit=461%2C346&ssl=1","jetpack_shortlink":"https:\/\/wp.me\/pbGGTT-2aN","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8357","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/comments?post=8357"}],"version-history":[{"count":2,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8357\/revisions"}],"predecessor-version":[{"id":9447,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/posts\/8357\/revisions\/9447"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media\/8359"}],"wp:attachment":[{"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/media?parent=8357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/categories?post=8357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ubiq.co\/tech-blog\/wp-json\/wp\/v2\/tags?post=8357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}