MariaDB - Versionsgeschichte

Geist: /* EASY BACKUP */

2022-06-15T14:08:54Z

EASY BACKUP

Geist: /* EASY BACKUP */

2022-06-15T14:07:18Z

EASY BACKUP

Geist am 15. Juni 2022 um 14:05 Uhr

2022-06-15T14:05:59Z

Geist: /* Find config files */

2022-06-15T11:06:22Z

Find config files

Geist am 15. Juni 2022 um 10:26 Uhr

2022-06-15T10:26:28Z

Geist am 13. Juni 2022 um 20:16 Uhr

2022-06-13T20:16:28Z

Geist am 7. April 2022 um 14:54 Uhr

2022-04-07T14:54:46Z

Geist: Die Seite wurde neu angelegt: „===== INIT SECURE DB ===== '''$ mysql_secure_installation''' ===== CREATE NEW USER|GRANT ALL PRIVILEGES ===== '''mysql> CREATE USER 'newuser'@'localhost' I…“

2022-04-07T14:40:41Z

Die Seite wurde neu angelegt: „===== INIT SECURE DB ===== '''$ mysql_secure_installation''' ===== CREATE NEW USER|GRANT ALL PRIVILEGES ===== '''mysql> CREATE USER 'newuser'@'localhost' I…“

Neue Seite

===== INIT SECURE DB =====

'''$ mysql_secure_installation'''

===== CREATE NEW USER|GRANT ALL PRIVILEGES =====
'''mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; '''
'''mysql> GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';'''
'''mysql> FLUSH PRIVILEGES;'''

@@ Zeile 2: / Zeile 2: @@
   '''[https://mariadb.com/kb/en/mariadb-dumpmysqldump/ mariadb-dump/mysqldump]'''
-.
+. Method -> mysqldump
   $ '''mysqldump -u root -p –all-databases > db.sql'''
   $ '''mysql -u root -p db < db.sql'''
   $ '''du -sh db.sql'''
-.
+. Method -> mariabackup
-  $ dnf -y install mariadb-backup
+  '''$ dnf -y install mariadb-backup'''
-  $ mariabackup --backup --target-dir /home/backup -u root -p password
+  '''$ mariabackup --backup --target-dir /home/backup -u root -p password'''
 ===== Find config files =====

@@ Zeile 1: / Zeile 1: @@
 === EASY BACKUP ===
-  [https://mariadb.com/kb/en/mariadb-dumpmysqldump/ mariadb-dump/mysqldump]
+  '''[https://mariadb.com/kb/en/mariadb-dumpmysqldump/ mariadb-dump/mysqldump]'''
 .
   $ '''mysqldump -u root -p –all-databases > db.sql'''
@@ Zeile 20: / Zeile 21: @@
   Default options are read from the following files in the given order:
-  /etc/my.cnf
+  '''/etc/my.cnf'''
-  /etc/mysql/my.cnf
+  '''/etc/mysql/my.cnf'''
-  /usr/etc/my.cnf
+  '''/usr/etc/my.cnf'''
-  ~/.my.cnf
+  '''$MYSQL_HOME/my.cnf'''
+  '''[datadir]/my.cnf'''
- etc/my.cnf
+  '''~/.my.cnf'''
 ===== SYSTEMCTL MARIADB =====
-  $ systemctl stop mariadb
+  '''$ systemctl stop mariadb'''
-  $ systemctl start mariadb
+  '''$ systemctl start mariadb'''
-  $ systemctl restart mariadb
+  '''$ systemctl restart mariadb'''
 ===== INIT SECURE DB =====

@@ Zeile 1: / Zeile 1: @@
 === EASY BACKUP ===
 .
   $ '''mysqldump -u root -p –all-databases > db.sql'''

@@ Zeile 10: / Zeile 10: @@
 ===== Find config files =====
   $ '''find / -name my.cnf'''
   $ '''mysqld --help --verbose'''
   Default options are read from the following files in the given order:
   /etc/my.cnf
   /etc/mysql/my.cnf
   /usr/etc/my.cnf
   ~/.my.cnf

@@ Zeile 8: / Zeile 8: @@
   $ dnf -y install mariadb-backup
   $ mariabackup --backup --target-dir /home/backup -u root -p password
 ===== SYSTEMCTL MARIADB =====

← Nächstältere Version		Version vom 13. Juni 2022, 20:16 Uhr
Zeile 1:		Zeile 1:
		+	=== EASY BACKUP ===
		+	1.
		+	$ '''mysqldump -u root -p –all-databases > db.sql'''
		+	$ '''mysql -u root -p db < db.sql'''
		+	$ '''du -sh db.sql'''
		+
		+	2.
		+	$ dnf -y install mariadb-backup
		+	$ mariabackup --backup --target-dir /home/backup -u root -p password
		+
		+	===== SYSTEMCTL MARIADB =====
		+	$ systemctl stop mariadb
		+	$ systemctl start mariadb
		+	$ systemctl restart mariadb
		+
	===== INIT SECURE DB =====		===== INIT SECURE DB =====
−
	'''$ mysql_secure_installation'''		'''$ mysql_secure_installation'''

@@ Zeile 4: / Zeile 4: @@
 ===== CREATE NEW USER|GRANT ALL PRIVILEGES =====
   '''mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; '''
   '''mysql> GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';'''
   '''mysql> FLUSH PRIVILEGES;'''