{"id":525,"date":"2018-03-13T01:20:29","date_gmt":"2018-03-12T17:20:29","guid":{"rendered":"https:\/\/vinta.ws\/code\/?p=525"},"modified":"2026-02-18T01:20:35","modified_gmt":"2026-02-17T17:20:35","slug":"import-mysql-database-but-ignore-specific-tables","status":"publish","type":"post","link":"https:\/\/vinta.ws\/code\/import-mysql-database-but-ignore-specific-tables.html","title":{"rendered":"Import MySQL database but ignore specific tables"},"content":{"rendered":"<p>You could just exclude tables you do not need.<\/p>\n<pre class=\"line-numbers\"><code class=\"language-console\">$ brew install gnu-sed --with-default-names\n$ sed -r '\/INSERT INTO <code>(table_to_skip_1|table_to_skip_2|table_to_skip_3)<\/code>\/d' db.20180101.sql &gt; db.reduced.sql<\/code><\/pre>\n<p>ref:<br \/>\n<a href=\"https:\/\/stackoverflow.com\/questions\/16735344\/mysql-import-database-but-ignore-specific-table\">https:\/\/stackoverflow.com\/questions\/16735344\/mysql-import-database-but-ignore-specific-table<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>You could just exclude tables you do not need.<\/p>\n","protected":false},"author":1,"featured_media":533,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22,38],"tags":[101,23],"class_list":["post-525","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-about-database","category-about-devops","tag-cli-tool","tag-mysql"],"_links":{"self":[{"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/posts\/525","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/comments?post=525"}],"version-history":[{"count":0,"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/posts\/525\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/media\/533"}],"wp:attachment":[{"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/media?parent=525"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/categories?post=525"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vinta.ws\/code\/wp-json\/wp\/v2\/tags?post=525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}