{"id":1269,"date":"2014-03-14T16:45:55","date_gmt":"2014-03-14T15:45:55","guid":{"rendered":"http:\/\/diesesinternet.de\/blog\/?p=1269"},"modified":"2014-11-25T21:49:43","modified_gmt":"2014-11-25T20:49:43","slug":"mysql-importexport-per-konsole","status":"publish","type":"post","link":"https:\/\/www.diesesinternet.de\/blog\/mysql-importexport-per-konsole\/","title":{"rendered":"MySQL Import\/Export per Konsole"},"content":{"rendered":"

Es gibt Sachen, die kann ich mir ums Verrecken<\/del> einfach nicht merken; zum Beispiel wie man MySQL-Datenbanken per Konsole sichert…<\/p>\n

<\/p>\n

Einzelne MySQL Datenbank exportieren<\/strong><\/p>\n

\n
<\/div>\n
\n\n\n\n
\n
\n
1<\/div>\n<\/div>\n<\/td>\n
\n
\n
mysqldump -u username -p database_name > dump.sql<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Die Struktur einer MySQL Datenbank exportieren<\/strong><\/p>\n

\n
<\/div>\n
\n\n\n\n
\n
\n
1<\/div>\n<\/div>\n<\/td>\n
\n
\n
mysqldump -u username -p –no-data database_name > dump.sql<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Die Daten aus einer MySQL Datenbank exportieren<\/strong><\/p>\n

\n
<\/div>\n
\n\n\n\n
\n
\n
1<\/div>\n<\/div>\n<\/td>\n
\n
\n
mysqldump -u username -p –no-create-info database_name > dump.sql<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Mehrere MySQL Datenbanken exportieren<\/strong><\/p>\n

\n
<\/div>\n
\n\n\n\n
\n
\n
1<\/div>\n<\/div>\n<\/td>\n
\n
\n
mysqldump -u username -p –databases db_name1 [db_name2 …] > dump.sql<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Alle MySQL Datenbanken exportieren<\/strong><\/p>\n

\n
<\/div>\n
\n\n\n\n
\n
\n
1<\/div>\n<\/div>\n<\/td>\n
\n
\n
mysqldump -u username -p –all-databases > dump.sql<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

MySQL Datenbanken importieren<\/strong><\/p>\n

\n
<\/div>\n
\n\n\n\n
\n
\n
1<\/div>\n<\/div>\n<\/td>\n
\n
\n
mysql -u username -p database_name < dump.sql<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Es gibt Sachen, die kann ich mir ums Verrecken einfach nicht merken; zum Beispiel wie man MySQL-Datenbanken per Konsole sichert…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[12],"_links":{"self":[{"href":"https:\/\/www.diesesinternet.de\/blog\/wp-json\/wp\/v2\/posts\/1269"}],"collection":[{"href":"https:\/\/www.diesesinternet.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.diesesinternet.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.diesesinternet.de\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.diesesinternet.de\/blog\/wp-json\/wp\/v2\/comments?post=1269"}],"version-history":[{"count":3,"href":"https:\/\/www.diesesinternet.de\/blog\/wp-json\/wp\/v2\/posts\/1269\/revisions"}],"predecessor-version":[{"id":1542,"href":"https:\/\/www.diesesinternet.de\/blog\/wp-json\/wp\/v2\/posts\/1269\/revisions\/1542"}],"wp:attachment":[{"href":"https:\/\/www.diesesinternet.de\/blog\/wp-json\/wp\/v2\/media?parent=1269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.diesesinternet.de\/blog\/wp-json\/wp\/v2\/categories?post=1269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.diesesinternet.de\/blog\/wp-json\/wp\/v2\/tags?post=1269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}