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 16: | Line 16: | ||
Confirm successful completion of the backup operation. | Confirm successful completion of the backup operation. | ||
| − | + | * The backup must be prepared: | |
<pre> | <pre> | ||
sudo mariabackup --prepare \ | sudo mariabackup --prepare \ | ||
Latest revision as of 05:36, 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.
