mysql-dump export:
\n mysqldump -h localhost -u root -p –all-databases –opt > \/root\/dump.sql<\/p>\n
mysql-dump import:
\nmysql -p
\nsource \/root\/dump.sql;
\nquit<\/p>\n
„ERROR 1045 (28000): Access denied for user ‚debian-sys-maint’@’localhost‘ (using password: YES)“
\num debiansysuser wieder zu berechtigen, falls db-dump von anderem server kommt:
\npasswort f\u00fcr debian-sys-maint user aus \/etc\/mysql\/debian.cnf auslesen
\nmysql -p
\nGRANT ALL PRIVILEGES ON *.* TO ‚debian-sys-maint’@’localhost‘ IDENTIFIED BY ‚ausgelesenesPasswort‘ WITH GRANT OPTION;
\nquit<\/p>\n
„ERROR 1577 (HY000) at line 1: Cannot proceed because system tables used by Event Scheduler were found damaged at server start“
\nbei versionsanhebung des mysql-servers:
\nmysql_upgrade -u root -h localhost -p –verbose –force<\/p>\n
„Verbindung f\u00fcr den controluser, wie er in Ihrer Konfiguration angegeben ist, ist fehlgeschlagen.“
\nphpmyadmin-rechte stimmen nicht, falls db-dump von anderem server kommt:
\nA) phpmyadmin neu installieren (beim deinstall purge!)
\nB) Berechtigungen f\u00fcr pma-user mit entsprechendem PW \u00fcberb\u00fcgeln und benutzerrechte neu laden \/ mysql-server neu starten
\nC) vorher gesicherte phpmyadmin-db zur\u00fcckspielen
\nIch empfehle Weg A, da dieser der einfachste (sofern man nicht irgendeine Sonderkonfig f\u00e4hrt) und auch sicherste ist (w\u00fcsste nicht, was man hier noch falsch machen kann \ud83d\ude09 )<\/p>\n","protected":false},"excerpt":{"rendered":"
mysql-dump export: mysqldump -h localhost -u root -p –all-databases –opt > \/root\/dump.sql mysql-dump import: mysql -p source \/root\/dump.sql; quit „ERROR 1045 (28000): Access denied for user ‚debian-sys-maint’@’localhost‘ (using password: YES)“ um debiansysuser wieder zu berechtigen, falls db-dump von anderem server kommt: passwort f\u00fcr debian-sys-maint user aus \/etc\/mysql\/debian.cnf auslesen mysql -p GRANT ALL PRIVILEGES ON *.*\u2026 Weiterlesen »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-289","post","type-post","status-publish","format-standard","hentry","category-computergedingens"],"_links":{"self":[{"href":"https:\/\/geisti.de\/index.php\/wp-json\/wp\/v2\/posts\/289","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/geisti.de\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/geisti.de\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/geisti.de\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/geisti.de\/index.php\/wp-json\/wp\/v2\/comments?post=289"}],"version-history":[{"count":0,"href":"https:\/\/geisti.de\/index.php\/wp-json\/wp\/v2\/posts\/289\/revisions"}],"wp:attachment":[{"href":"https:\/\/geisti.de\/index.php\/wp-json\/wp\/v2\/media?parent=289"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/geisti.de\/index.php\/wp-json\/wp\/v2\/categories?post=289"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/geisti.de\/index.php\/wp-json\/wp\/v2\/tags?post=289"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}