{"id":215,"date":"2013-04-02T21:34:46","date_gmt":"2013-04-02T21:34:46","guid":{"rendered":"http:\/\/blog.datentraeger.li\/?p=215"},"modified":"2017-02-22T21:35:50","modified_gmt":"2017-02-22T21:35:50","slug":"mysql-datenstruktur-exportieren","status":"publish","type":"post","link":"https:\/\/blog.datentraeger.li\/?p=215","title":{"rendered":"MySQL Datenstruktur exportieren"},"content":{"rendered":"<p>Gestern stand ich vor der Frage, wie ich aus einer Datenbank nur die Struktur, also alle Tabellen ohne Daten exportieren kann. Eigentlich ganz einfach \u2013 identisch mit einem ganz normalen Dump, bis auf die -d Option, die bewirkt, dass keine Daten exportiert werden:<\/p>\n<pre lang=\"bash\" line=\"1\">mysqldump -d -u root -ppassword dbname > dumpfile.sql<\/pre>\n","protected":false},"excerpt":{"rendered":"Gestern stand ich vor der Frage, wie ich aus einer Datenbank nur die Struktur, also alle Tabellen ohne Daten exportieren kann. Eigentlich ganz einfach \u2013 identisch mit einem ganz normalen Dump, bis auf die -d Option, die bewirkt, dass keine Daten exportiert werden: mysqldump -d -u root -ppassword dbname >&hellip;\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,16],"tags":[],"class_list":["post-215","post","type-post","status-publish","format-standard","hentry","category-database","category-sql"],"_links":{"self":[{"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/posts\/215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=215"}],"version-history":[{"count":1,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/posts\/215\/revisions"}],"predecessor-version":[{"id":216,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=\/wp\/v2\/posts\/215\/revisions\/216"}],"wp:attachment":[{"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.datentraeger.li\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}