{"id":8152,"date":"2017-06-01T11:19:55","date_gmt":"2017-06-01T03:19:55","guid":{"rendered":"http:\/\/jpuyy.com\/?p=8152"},"modified":"2017-06-01T11:28:29","modified_gmt":"2017-06-01T03:28:29","slug":"mysqldump-ignore-table","status":"publish","type":"post","link":"https:\/\/jpuyy.com\/?p=8152","title":{"rendered":"mysqldump ignore table"},"content":{"rendered":"<p>mysqldump \u5ffd\u7565\u4e00\u4e9b\u8868<\/p>\n<pre>\r\n--ignore-table=name   Do not dump the specified table. To specify more than one\r\n                      table to ignore, use the directive multiple times, once\r\n                      for each table.  Each table must be specified with both\r\n                      database and table names, e.g.,\r\n                     --ignore-table=database.table\r\n<\/pre>\n<p>\u4f8b\u5b50<\/p>\n<pre>\r\nmysqldump -u dw -p dw --ignore-table=dw.raw_tracking --ignore-table=dw.raw_access > dump_without_tracking_access.sql<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>mysqldump \u5ffd\u7565\u4e00\u4e9b\u8868 &#8211;ignore-table=name Do not dump the specified table. To specify more than one table to ignore, use the directive multiple times, once for each table. Each table must be specified with both database and table names, e.g., &#8211;ignore-table=database.table \u4f8b\u5b50 mysqldump -u dw -p dw &#8211;ignore-table=dw.raw_tracking &#8211;ignore-table=dw.raw_access > dump_without_tracking_access.sql<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[65],"tags":[],"class_list":["post-8152","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/8152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8152"}],"version-history":[{"count":2,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/8152\/revisions"}],"predecessor-version":[{"id":8154,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/8152\/revisions\/8154"}],"wp:attachment":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}