Changes between Version 7 and Version 8 of Backup


Ignore:
Timestamp:
11/15/25 14:48:21 (10 days ago)
Author:
222039
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • Backup

    v7 v8  
    1010 * '''Само структура (без податоци):''' `mysqldump -u root -p --no-data airportdb > schema_only.sql`
    1111
     12=== Physical Backup
    1213
    13 
    14 === Physical Backup
     14* '''Целосен physical backup:''' `mysqlbackup --backup-dir=/backup/full_backup backup`
     15* '''XtraBackup (Инсталација треба првин):'''
     16 * Чекор 1: `xtrabackup --backup --target-dir=/backups/full_backup`
     17 * Чекор 2: `xtrabackup --prepare --target-dir=/backups/full_backup`
     18 * Чекор 3: restoration
     19* '''Manual Backup:'''
     20 * Чекор 1: Stop MySQL - net stop MySQL80 / sudo systemctl stop mysql
     21 * Чекор 2: Копирање на MySQL data directory - C:\ProgramData\MySQL\MySQL Server 8.0\Data | /var/lib/mysql/
     22 * Чекор 3: Start MySQL - net start MySQL80 / sudo systemctl start mysql
    1523
    1624== Restoration