{"id":806,"date":"2023-02-12T16:28:58","date_gmt":"2023-02-12T15:28:58","guid":{"rendered":"https:\/\/iso.spdns.de\/?page_id=806"},"modified":"2023-02-19T18:06:45","modified_gmt":"2023-02-19T17:06:45","slug":"mysql-datenbank-sichern-und-wiederherstellen","status":"publish","type":"page","link":"https:\/\/iso.spdns.de\/?page_id=806","title":{"rendered":"mysql Datenbank: Wichtige Befehle"},"content":{"rendered":"\n

MySQL Dump<\/h2>\n\n\n\n

Folgende mysqldump Zeile speichert alle Datenbanken, die f\u00fcr den User \u201eroot\u201c freigegeben sind in der Datei my-mysql-dump.sql<\/p>\n\n\n\n

mysqldump -u root -p --all-databases > my-mysql-dump.sql<\/code><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Folgende mysqldump Zeile stellt alle Datenbanken wieder her, die f\u00fcr den User \u201eroot\u201c freigegeben sind.<\/p>\n\n\n\n

<\/p>\n\n\n\n

mysqldump -u root -p --all-databases < my-mysql-dump.sql<\/code><\/p>\n\n\n\n

Passwort setzen, wenn root noch kein Passwort hat<\/strong><\/p>\n\n\n\n

# mysqladmin -u root password NEUESPASSWORT<\/p>\n\n\n\n

Einloggen in das Datenbanksystem \u00fcber die Shell<\/p>\n\n\n\n

\n\n\n\n

mysql -u root -p<\/p>\n\n\n\n

\n\n\n\n

Listings 2:<\/strong> Bestehende User anzeigen lassen<\/p>\n\n\n\n

\n\n\n\n

SELECT user FROM mysql.user;<\/p>\n\n\n\n

\n\n\n\n

Listings 3:<\/strong> Bestehende Datenbanken anzeigen<\/p>\n\n\n\n

\n\n\n\n

show databases;<\/p>\n\n\n\n

\n\n\n\n

Listing 4:<\/strong> Einen neuen User mit einem sicheren Passwort anlegen<\/p>\n\n\n\n

\n\n\n\n

CREATE USER ’neuerUser’@’localhost‘ IDENTIFIED BY ’sicheresPasswort‘;<\/p>\n\n\n\n

\n\n\n\n

Listing 5: <\/strong>Neue Datenbank anlegen<\/p>\n\n\n\n

\n\n\n\n

CREATE DATABASE  neueDatenbank;<\/p>\n\n\n\n

\n\n\n\n

Listing 6:<\/strong> Dem neuen User komplette Rechte f\u00fcr die Datenbank zuweisen<\/p>\n\n\n\n

\n\n\n\n

GRANT ALL PRIVILEGES ON neueDatenbank . * TO ’neuerUser’@’localhost‘;<\/p>\n\n\n\n

\n\n\n\n

Listing 7:<\/strong> Einem User komplette Rechte auf alle Datenbank zuweisen<\/p>\n\n\n\n

\n\n\n\n

GRANT ALL PRIVILEGES ON *. * TO ’neuerUser’@’localhost‘;<\/p>\n\n\n\n

\n\n\n\n

Listing 8:<\/strong> Abschlie\u00dfend muss sichergestellt werden, dass die Rechte in der Datenbank auch geladen werden.<\/p>\n\n\n\n

\n\n\n\n

FLUSH PRIVILEGES;<\/p>\n\n\n\n

\n","protected":false},"excerpt":{"rendered":"

MySQL Dump Folgende mysqldump Zeile speichert alle Datenbanken, die f\u00fcr den User \u201eroot\u201c freigegeben sind in der Datei my-mysql-dump.sql mysqldump -u root -p –all-databases > my-mysql-dump.sql Folgende mysqldump Zeile stellt alle Datenbanken wieder her, die f\u00fcr den User \u201eroot\u201c freigegeben sind. mysqldump -u root -p –all-databases < my-mysql-dump.sql Passwort setzen, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-806","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/iso.spdns.de\/index.php?rest_route=\/wp\/v2\/pages\/806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/iso.spdns.de\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/iso.spdns.de\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/iso.spdns.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/iso.spdns.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=806"}],"version-history":[{"count":6,"href":"https:\/\/iso.spdns.de\/index.php?rest_route=\/wp\/v2\/pages\/806\/revisions"}],"predecessor-version":[{"id":838,"href":"https:\/\/iso.spdns.de\/index.php?rest_route=\/wp\/v2\/pages\/806\/revisions\/838"}],"wp:attachment":[{"href":"https:\/\/iso.spdns.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}