Changes between Version 11 and Version 12 of Backup

Timestamp:

11/15/25 15:12:53 (10 days ago)

Author:

222039

Comment:

--

Backup

@@ -13 +13 @@
 
 * '''Целосен physical backup:''' `mysqlbackup --backup-dir=/backup/full_backup backup`
-* '''XtraBackup (Инсталација треба првин):''' 
+* '''XtraBackup (САМО ЗА LINUX!!!):''' 
  * Чекор 1: `xtrabackup --backup --target-dir=/backups/full_backup`
  * Чекор 2: `xtrabackup --prepare --target-dir=/backups/full_backup`
@@ -41 +41 @@
 * '''Start MySQL:''' net start MySQL80 | sudo systemctl stop mysql`
 
+* '''XtraBackup:'''
+ * '''Подготовка на backup-от:''' xtrabackup --prepare --target-dir=/backups/full_backup
+ * '''Stop MySQL:''' `net stop MySQL80 | sudo systemctl stop mysql`
+ * '''Враќање на backup-от:''' `sudo xtrabackup --copy-back --target-dir=/backups/full_backup`
+ * '''Поставување на дозволи:''' `sudo chown -R mysql:mysql /var/lib/mysql`
+ * '''Start MySQL:''' net start MySQL80 | sudo systemctl stop mysql`
+
 
 == Point-in-Time Recovery (PITR)