{"id":382,"date":"2012-06-28T00:40:58","date_gmt":"2012-06-27T17:40:58","guid":{"rendered":"http:\/\/www.randomlog.org\/?p=382"},"modified":"2015-01-10T20:19:50","modified_gmt":"2015-01-10T13:19:50","slug":"mysql-backupdump-prefixed-tables-only","status":"publish","type":"post","link":"https:\/\/randomlog.org\/blog\/mysql-backupdump-prefixed-tables-only","title":{"rendered":"MySQL &#8211; backup\/dump prefixed tables only"},"content":{"rendered":"<p>You&#8217;ll need this if you only have access to a single database, with many tables from many apps in it -_-<\/p>\n<p><code>mysqldump -u USER -p DATABASE $(mysql -u USER -p -D DATABASE -Bse \"show tables like 'PREFIX%'\") &gt; \/target\/file.sql<\/code><\/p>\n<p><a href=\"http:\/\/stackoverflow.com\/questions\/2949330\/mysqldump-more-than-one-table\">http:\/\/stackoverflow.com\/questions\/2949330\/mysqldump-more-than-one-table<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>You&#8217;ll need this if you only have access to a single database, with many tables from many apps in it -_- mysqldump -u USER -p DATABASE $(mysql -u USER -p -D DATABASE -Bse &#8220;show tables like &#8216;PREFIX%'&#8221;) &gt; \/target\/file.sql http:\/\/stackoverflow.com\/questions\/2949330\/mysqldump-more-than-one-table<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[36],"class_list":["post-382","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-mobile"],"_links":{"self":[{"href":"https:\/\/randomlog.org\/blog\/wp-json\/wp\/v2\/posts\/382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/randomlog.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/randomlog.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/randomlog.org\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/randomlog.org\/blog\/wp-json\/wp\/v2\/comments?post=382"}],"version-history":[{"count":2,"href":"https:\/\/randomlog.org\/blog\/wp-json\/wp\/v2\/posts\/382\/revisions"}],"predecessor-version":[{"id":488,"href":"https:\/\/randomlog.org\/blog\/wp-json\/wp\/v2\/posts\/382\/revisions\/488"}],"wp:attachment":[{"href":"https:\/\/randomlog.org\/blog\/wp-json\/wp\/v2\/media?parent=382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/randomlog.org\/blog\/wp-json\/wp\/v2\/categories?post=382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/randomlog.org\/blog\/wp-json\/wp\/v2\/tags?post=382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}