Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- it-wiki:mysql:faq [2023/03/24 07:17] – [Find and Remove Unused Indexes] marko
+++ it-wiki:mysql:faq [2023/03/24 07:18] (aktuell) – [Tips to reduce the size of MySQL Database] marko
@@ Zeile 42: / Zeile 42: @@
 ===== Tips to reduce the size of MySQL Database =====
+==== Backup, first but not least ====
+Best practices suggest to backup your database before take any dangerous action. MySQL and MariaDB include the mysqldump utility to simplify the process to create a backup of a database or system of databases.
+<code bash>
+# Backup Single DB
+mysqldump -u [username] -p [databaseName] > [filename]-$(date +%F).sql
+# Backup Entire DBMS
+mysqldump --all-databases --single-transaction --quick --lock-tables=false > full-backup-$(date +%F).sql -u root -p
+</code>
+If you are using MariaDB, you have the option of  full or incremental backup via ''mariabackup'' utility.
+<code bash>
+$ mariabackup --backup --target-dir=/var/mariadb/backup/ --user=myuser --password=mypassword
+</code>
 ==== List MySQL Table and Index Size ====
 Use the following queries to monitor and evaluation table and index size.