{"id":1180,"date":"2022-02-22T13:22:47","date_gmt":"2022-02-22T12:22:47","guid":{"rendered":"https:\/\/wiki.ad-libitum.info\/?page_id=1180"},"modified":"2022-02-22T13:22:47","modified_gmt":"2022-02-22T12:22:47","slug":"mysql-datenbank-sichern-und-wiederherstellen-unter-xampp-auf-windows","status":"publish","type":"page","link":"https:\/\/wiki.ad-libitum.info\/?page_id=1180","title":{"rendered":"MySQL-Datenbank sichern und wiederherstellen unter XAMPP auf Windows"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Backup<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysqldump --user root --password  --all-databases &gt; all-databases.sql<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Restore komplett<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql --user root --password mysql &lt; all-databases.sql<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Restore einzelne Tabelle<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">mysql --user root --password [db_name] &lt; [db_name].sql<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Backup mysqldump &#8211;user root &#8211;password &#8211;all-databases &gt; all-databases.sql Restore komplett mysql &#8211;user root &#8211;password mysql &lt; all-databases.sql Restore einzelne Tabelle mysql &#8211;user root &#8211;password [db_name] &lt; [db_name].sql<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1180","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/wiki.ad-libitum.info\/index.php?rest_route=\/wp\/v2\/pages\/1180","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki.ad-libitum.info\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/wiki.ad-libitum.info\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/wiki.ad-libitum.info\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki.ad-libitum.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1180"}],"version-history":[{"count":0,"href":"https:\/\/wiki.ad-libitum.info\/index.php?rest_route=\/wp\/v2\/pages\/1180\/revisions"}],"wp:attachment":[{"href":"https:\/\/wiki.ad-libitum.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}