MariaDB - Redigeerimiste ajalugu

Imre: /* Taastamine */

2026-01-15T08:31:44Z

Taastamine

←Vanem redaktsioon		Redaktsioon: 15. jaanuar 2026, kell 11:31
149. rida:		149. rida:
	<pre>		<pre>
	root@pwrk-02:~# systemctl stop mariadb		root@pwrk-02:~# systemctl stop mariadb
		+	root@pwrk-02:~# ps U mysql
		+	root@pwrk-02:~#
		+
		+	root@pwrk-02:~# mv /var/lib/mysql/ /var/lib/mysql-tootanud
	root@pwrk-02:~# mariadb-backup --prepare --target-dir=/root/mariadb-backup-2		root@pwrk-02:~# mariadb-backup --prepare --target-dir=/root/mariadb-backup-2
	root@pwrk-02:~# mariadb-backup --copy-back --target-dir=/root/mariadb-backup-2		root@pwrk-02:~# mariadb-backup --copy-back --target-dir=/root/mariadb-backup-2

2026-01-15T08:31:00Z

Varundamine

←Vanem redaktsioon		Redaktsioon: 15. jaanuar 2026, kell 11:31
139. rida:		139. rida:

	<pre>		<pre>
		+	root@pwrk-02:~# systemctl start mariadb
	root@pwrk-02:~# mariadb-backup --backup --target-dir=/root/mariadb-backup-2 --user=mariadb-backup --password=parool		root@pwrk-02:~# mariadb-backup --backup --target-dir=/root/mariadb-backup-2 --user=mariadb-backup --password=parool
	</pre>		</pre>

2026-01-15T08:30:40Z

mariadb-backup kasutamine

←Vanem redaktsioon		Redaktsioon: 15. jaanuar 2026, kell 11:30
145. rida:		145. rida:

	TODO		TODO
		+
		+	<pre>
		+	root@pwrk-02:~# systemctl stop mariadb
		+	root@pwrk-02:~# mariadb-backup --prepare --target-dir=/root/mariadb-backup-2
		+	root@pwrk-02:~# mariadb-backup --copy-back --target-dir=/root/mariadb-backup-2
		+	root@pwrk-02:~# chown -R mysql:mysql /var/lib/mysql
		+	root@pwrk-02:~# systemctl start mariadb
		+	</pre>

	====Kasulikud lisamaterjalid====		====Kasulikud lisamaterjalid====

2026-01-15T07:44:51Z

mariadb-backup kasutamine

@@ 133. rida: / 133. rida: @@
 GRANT RELOAD, PROCESS, LOCK TABLES, BINLOG MONITOR ON *.* TO 'mariadb-backup'@'localhost';
 </pre>
 ====Kasulikud lisamaterjalid====

2026-01-15T07:29:15Z

mariadb-backup kasutamine

←Vanem redaktsioon		Redaktsioon: 15. jaanuar 2026, kell 10:29
126. rida:		126. rida:

	TODO		TODO
		+
		+	====Kasutaja tekitamine====
		+
		+	<pre>
		+	CREATE USER 'mariadb-backup'@'localhost' IDENTIFIED BY 'parool';
		+	GRANT RELOAD, PROCESS, LOCK TABLES, BINLOG MONITOR ON . TO 'mariadb-backup'@'localhost';
		+	</pre>

	====Kasulikud lisamaterjalid====		====Kasulikud lisamaterjalid====

2026-01-15T07:24:08Z

Kasulikud lisamaterjalid

←Vanem redaktsioon		Redaktsioon: 15. jaanuar 2026, kell 10:24
120. rida:		120. rida:

	TODO		TODO
		+
		+	===mariadb-backup kasutamine===
		+
		+	====Tööpõhimõte====
		+
		+	TODO
		+
		+	====Kasulikud lisamaterjalid====
		+
		+	* https://mariadb.com/docs/server/server-usage/backup-and-restore/mariadb-backup/mariadb-backup-overview
		+	* https://www.youtube.com/watch?v=xB4ImmmzXqU

	===Kasulikud lisamaterjalid===		===Kasulikud lisamaterjalid===

2025-03-13T01:20:38Z

←Vanem redaktsioon		Redaktsioon: 13. märts 2025, kell 04:20
20. rida:		20. rida:

	<pre>		<pre>
−	MariaDB [(none)]> CREATE DATABASE projektinimi CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;	+	MariaDB [(none)]> CREATE DATABASE projektinimi CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
	MariaDB [(none)]> grant all privileges on projektinimi.* to 'projektinimi'@'%' identified by 'parool';		MariaDB [(none)]> grant all privileges on projektinimi.* to 'projektinimi'@'%' identified by 'parool';
	MariaDB [(none)]> grant all privileges on projektinimi.* to 'projektinimi'@'localhost' identified by 'parool';		MariaDB [(none)]> grant all privileges on projektinimi.* to 'projektinimi'@'localhost' identified by 'parool';

2025-03-07T00:31:04Z

@@ 90. rida: / 90. rida: @@
 * https://database.guide/show-the-collation-in-mariadb/
 * https://mariadb.com/kb/en/show-collation/
 ====Paigaldamine tootja repost====

2025-03-07T00:22:37Z

Collation jms

@@ 69. rida: / 69. rida: @@
 rows in set (0.000 sec)
 <pre>
 Kasulikud lisamaterjalid

2025-03-07T00:21:51Z

Collation jms

@@ 56. rida: / 56. rida: @@
 ...
 </pre>
 Kasulikud lisamaterjalid