Difference between revisions of "MariaDB"
(→Backup & Restore) |
(→Backup & Restore) |
||
Line 7: | Line 7: | ||
refer to https://mariadb.com/docs/recovery/backup-optimization/ | refer to https://mariadb.com/docs/recovery/backup-optimization/ | ||
+ | Take a full backup: | ||
<pre> | <pre> | ||
sudo mariabackup --backup \ | sudo mariabackup --backup \ | ||
Line 12: | Line 13: | ||
--password=P@ssw0rdINDO7Kali \ | --password=P@ssw0rdINDO7Kali \ | ||
--target-dir=/home/backup/db | --target-dir=/home/backup/db | ||
+ | </pre> | ||
+ | Confirm successful completion of the backup operation. | ||
+ | The backup must be prepared: | ||
+ | <pre> | ||
sudo mariabackup --prepare \ | sudo mariabackup --prepare \ | ||
--target-dir=/home/backup/db | --target-dir=/home/backup/db | ||
</pre> | </pre> | ||
+ | Confirm successful completion of the prepare operation. | ||
== Monitor Index status dan size for optimization == | == Monitor Index status dan size for optimization == |
Revision as of 05:35, 17 April 2022
Contents
Introduction
Database Maintenance and Monitoring script
Backup & Restore
refer to https://mariadb.com/docs/recovery/backup-optimization/
Take a full backup:
sudo mariabackup --backup \ --user=root \ --password=P@ssw0rdINDO7Kali \ --target-dir=/home/backup/db
Confirm successful completion of the backup operation.
The backup must be prepared:
sudo mariabackup --prepare \ --target-dir=/home/backup/db
Confirm successful completion of the prepare operation.