Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
mariadb_mysql [04/11/2023 - 14:14] – thommie4 | mariadb_mysql [17/08/2024 - 07:06] (aktuell) – Externe Bearbeitung 127.0.0.1 | ||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
- | ====== Reset root Passwort | + | ====== MYSQL und MARIADB ====== |
+ | |||
+ | ===== Reset root Passwort ===== | ||
Version ermitteln | Version ermitteln | ||
Zeile 29: | Zeile 31: | ||
Danach mysql stoppen und wieder normal starten. | Danach mysql stoppen und wieder normal starten. | ||
- | **Variante 2: Password mit initialer Textdatei setzen** | + | ===== Variante 2: Password mit initialer Textdatei setzen |
Create a text file containing the password-assignment statement on a single line. Replace the password with the password that you want to use. | Create a text file containing the password-assignment statement on a single line. Replace the password with the password that you want to use. | ||
Zeile 57: | Zeile 59: | ||
</ | </ | ||
- | ====== MySQL per shell ====== | + | ===== MySQL per shell ===== |
Login | Login | ||
Zeile 72: | Zeile 74: | ||
</ | </ | ||
+ | Remote Login | ||
- | ===== Dump von Datenbanken ===== | + | < |
+ | mysql -u username -p password -h [host] -D [database] | ||
- | < | ||
- | root@db1b: | ||
- | Usage: mariadb-dump [OPTIONS] database [tables] | ||
- | OR | ||
- | OR | ||
- | OR | ||
- | For more options, use mariadb-dump --help | ||
</ | </ | ||
+ | |||
===== MySQL Replikation ===== | ===== MySQL Replikation ===== | ||
Zeile 170: | Zeile 168: | ||
| GRANT ALL PRIVILEGES ON `joomla`.`joomla` TO ' | | GRANT ALL PRIVILEGES ON `joomla`.`joomla` TO ' | ||
+-------------------------------------------------------------------------------------------------------+ | +-------------------------------------------------------------------------------------------------------+ | ||
+ | </ | ||
+ | |||
+ | ===== Dump von Datenbanken ===== | ||
+ | |||
+ | < | ||
+ | root@db1b: | ||
+ | Usage: mariadb-dump [OPTIONS] database [tables] | ||
+ | OR | ||
+ | OR | ||
+ | OR | ||
+ | For more options, use mariadb-dump --help | ||
+ | </ | ||
+ | |||
+ | ===== Shell-Import von Datenbanken ===== | ||
+ | |||
+ | < | ||
+ | root@maria1:/ | ||
+ | |||
+ | mysql -u root -p rcube < rcube.sql | ||
</ | </ | ||