Get the most out of your Centmin Mod LEMP stack
Become a Member

Beta Branch update centmin.sh menu option 21 submenu option 3 in 130.00beta01

Discussion in 'Centmin Mod Github Commits' started by eva2000, May 5, 2023.

  1. eva2000

    eva2000 Administrator Staff Member

    58,895
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:33 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    update centmin.sh menu option 21 submenu option 3 in 130.00beta01

    - first draft version of centmin.sh menu option 21 submenu option 3 for backup Nginx vhost data + MySQL data (via 2 method options MariaBackup or mysqldump) + also SSH transfer to remote server

    Continue reading...

    130.00beta01 branch

    Support Centmin Mod


    If you find Centmin Mod useful, please help support Centmin Mod

     
  2. eva2000

    eva2000 Administrator Staff Member

    58,895
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:33 PM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    centmin.sh menu option 21 submenu option 3 for backup and transfer data to remote server via SSH
    Code (Text):
    --------------------------------------------------------
         Centmin Mod Data Management      
    --------------------------------------------------------
    1).   Manage SSH Keys
    2).   Manage AWS CLI S3 Profile Credentials
    3).   Migrate Centmin Mod Data To New Centmin Mod Server
    4).   Backup Nginx Vhosts Data + MariaBackup MySQL Backups
    5).   Backup Nginx Vhosts Data Only (no MariaDB MySQL backups)
    6).   Backup MariaDB MySQL With MariaBackup Only (no Vhosts Data backups)
    7).   Backup MariaDB MySQL With mysqldump only (no Vhosts Data backups)
    8).   Transfer Directory Data To Remote Server Via SSH
    9).   Transfer Directory Data To S3 Compatible Storage
    10).  Transfer Files To S3 Compatible Storage
    11).  Download S3 Compatible Stored Data To Server
    12).  S3 To S3 Compatible Storage Transfers
    13).  List S3 Storage Buckets
    14).  Back to Main menu
    --------------------------------------------------------
    Enter option [ 1 - 14 ] 3
    --------------------------------------------------------
    

    Running submenu option 3 gives 2 methods of backup to choose from
    Code (Text):
    Migrate Centmin Mod Data To New Centmin Mod Server
    Description:
    This option is for full Nginx vhost data and MariaDB MySQL data transfers from
    this server to a new Centmin Mod based server. There are specific requirements
    for this to work:
    1. The destination server must already have Centmin Mod LEMP stack installed
    2. The destination server and this server's MairaDB MySQL server versions must
       be the same major version at least. i.e. MariaDB 10.3 or both
    Do you want to continue [y/n]: y
    Choose the backup method:
    1) Backup Nginx Vhosts Data + MariaBackup MySQL Backups
    2) Backup Nginx Vhosts Data + Backup MariaDB MySQL With mysqldump
    

    Option 1 Backup Nginx Vhosts Data + MariaBackup MySQL Backups

    Code (Text):
    Enter the backup method (1 or 2): 1
    
    Backup Nginx Vhosts Data + MariaBackup MySQL Backups
    
    Description:
    This option is for full Nginx vhost data and MariaDB MySQL backups using
    tar + zstd compression is optional. If you choose not to use tar + zstd
    the local backup directories will have uncompressed data backups.
    
    Do you want to continue [y/n]: y
    Do you want tar + zstd compress backup [y/n]: y
    [Fri May  5 00:11:06 EDT 2023] Total uncompressed size of all directories to be backed up: 353.81MB
    [Fri May  5 00:11:06 EDT 2023] Free space available on /home: 13.13GB
    [Fri May  5 00:11:06 EDT 2023] Creating temporary domain data directory ...
    [Fri May  5 00:11:06 EDT 2023] Copying domain data (excluding logs) ...
    [Fri May  5 00:11:08 EDT 2023] Creating temporary MariaDB data directory ...
    [Fri May  5 00:11:08 EDT 2023] Performing MariaBackup To /home/databackup/050523-001106/mariadb_tmp ...
    [Fri May  5 00:11:10 EDT 2023] Preparing MariaBackup At /home/databackup/050523-001106/mariadb_tmp ...
    [Fri May  5 00:11:11 EDT 2023] /home/databackup/050523-001106/mariadb_tmp/mariabackup-restore.sh saved
    [Fri May  5 00:11:11 EDT 2023] MariaBackup log saved at /home/databackup/050523-001106/mariadb_tmp/mariabackup_050523-001106.log
    [Fri May  5 00:11:11 EDT 2023] Creating backup tarball using zstd compression (-T2 --fast=4)
    [Fri May  5 00:11:17 EDT 2023] Cleaning up temporary directories ...
    [Fri May  5 00:11:17 EDT 2023] Backup completed. File: /home/databackup/050523-001106/centminmod_backup.tar.zst
    [Fri May  5 00:11:17 EDT 2023] Backup Log saved: /home/databackup/050523-001106/files-backup_050523-001106.log
    [Fri May  5 00:11:17 EDT 2023] Script execution time: 11 seconds
    
    Backup Directory: /home/databackup/050523-001106
    

    Code (Text):
    Do you want to transfer the backup directory to remote server via SSH? [y/n/exit]: y
    
    Transfer /home/databackup/050523-001106 Directory Data To Remote Server Via SSH
    
    Description:
    Option allows you to specify a full path to directory name for data transfer
    to a remote server via SSH at speeds near network and disk line rates using
    either netcat (nc) or socat compressed tunnel using zstd fast compression levels
    
    Do you want to continue [y/n]: y
    Remote server SSH port (default: 22): 22
    Remote server SSH username (default: root): root
    Remote server SSH hostname/IP address: 123.123.123.123
    Tunnel method (nc or socat, default: nc): nc
    Buffer size for socat (in bytes, e.g., 131072 for 128 KB): 262144
    Listen port for nc or socat (default: 12345): 12345
    Source backup directory: /home/databackup/050523-001106
    Remote (destination) backup directory: /home/remotebackup/
    Path to the SSH private key: /root/.ssh/my1.key
    
    Please confirm the entered information:
    Remote server SSH port: 22
    Remote server SSH username: root
    Remote server SSH hostname/IP address: 123.123.123.123
    Tunnel method: nc
    Buffer size: 262144
    Listen port: 12345
    Source backup directory: /home/databackup/050523-001106
    Remote (destination) backup directory: /home/remotebackup/
    Path to the SSH private key: /root/.ssh/my1.key
    
    Is the information correct? [y/n]: y
    /usr/local/src/centminmod/datamanagement/tunnel-transfers.sh -p 22 -u root -h 123.123.123.123 -m nc -b 262144 -l 12345 -s /home/databackup/050523-001106 -r /home/remotebackup/ -k /root/.ssh/my1.key
    Transfer completed successfully in 1 seconds.
    

    Remote server directory's contents
    Code (Text):
    ls -lah /home/remotebackup/
    total 247M
    drwxr-xr-x   2 root root 4.0K May  5 00:11 .
    drwxr-xr-x. 18 root root 4.0K May  4 20:21 ..
    -rw-r--r--   1 root root 245M May  5 00:11 centminmod_backup.tar.zst
    -rw-r--r--   1 root root 1.6M May  5 00:11 files-backup_050523-001106.log
    


    Option 2 Backup Nginx Vhosts Data + Backup MariaDB MySQL With mysqldump

    Code (Text):
    Enter the backup method (1 or 2): 2
    
    Backup Nginx Vhosts Data Only (no MariaDB MySQL backups)
    
    Vhosts backup:
    This option is for full Nginx vhost data backups
    using tar + zstd compression is optional. If you choose not to use tar + zstd
    the local backup directories will have uncompressed data backups.
    
    MySQL backup:
    For MariaDB MySQL database backups using mysqldump native client
    client but uses faster --tab delimited backup option which backups up each MySQL
    database table as separate .sql schema structure files + .txt data files rather
    than as a single .sql database backup file which contains both schema + data.
    The .sql database schema only table files are never compressed while .txt data
    files can optionally be zstd compressed or left uncompressed.
    
    The routine generates a restore.sh script in the destination backup directory
    The restore.sh can be run to restore each database or all databases on a new
    server. If the database name already exists on the server, it will restore to
    a new database name with suffix added _restorecopy_datetimestamp to prevent
    overwriting the existing database name.
    
    Do you want tar + zstd compress backup [y/n]: y
    [Fri May  5 01:36:02 EDT 2023] Total uncompressed size of all directories to be backed up: 353.81MB
    [Fri May  5 01:36:02 EDT 2023] Free space available on /home: 17.56GB
    [Fri May  5 01:36:02 EDT 2023] Creating temporary domain data directory ...
    [Fri May  5 01:36:02 EDT 2023] Copying domain data (excluding logs) ...
    [Fri May  5 01:36:05 EDT 2023] Creating backup tarball using zstd compression (-T2 --fast=4)
    [Fri May  5 01:36:10 EDT 2023] Cleaning up temporary directories ...
    [Fri May  5 01:36:10 EDT 2023] Backup completed. File: /home/databackup/050523-013602/centminmod_backup.tar.zst
    [Fri May  5 01:36:10 EDT 2023] Backup Log saved: /home/databackup/050523-013602/files-backup_050523-013602.log
    [Fri May  5 01:36:10 EDT 2023] Script execution time: 8 seconds
    [Fri May  5 01:36:11 EDT 2023] backup database: mysql (1.38281 MB)
    [Fri May  5 01:36:11 EDT 2023] backup time for mysql: 0.03s
    [Fri May  5 01:36:11 EDT 2023] backup database: sakila (23.8555 MB)
    [Fri May  5 01:36:11 EDT 2023] backup time for sakila: 0.08s
    [Fri May  5 01:36:11 EDT 2023] backup database: wp3233312196db_24171 (11.543 MB)
    [Fri May  5 01:36:11 EDT 2023] backup time for wp3233312196db_24171: 0.01s
    
    [Fri May  5 01:36:11 EDT 2023] MySQL backup completed. MASTER_LOG_FILE and MASTER_LOG_POS: mysql-bin.000078,342
    [Fri May  5 01:36:11 EDT 2023] Restore script generated: /home/mysqlbackup/mysql/050523-013610/restore.sh
    [Fri May  5 01:36:11 EDT 2023] Master Info log generated: /home/mysqlbackup/mysql/050523-013610/master_info.log
    [Fri May  5 01:36:11 EDT 2023] Backup log file generated: /var/log/mysql_backup_050523-013610.log
    [Fri May  5 01:36:11 EDT 2023] Backup size: 2524 KB
    [Fri May  5 01:36:11 EDT 2023] Backup saved to /home/mysqlbackup/mysql/050523-013610
    
    [Fri May  5 01:36:11 EDT 2023] Starting binlog backup process...
    [Fri May  5 01:36:11 EDT 2023] Total size of mysql-bin files: 3.50124 MB
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000001
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000002
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000003
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000004
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000005
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000006
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000007
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000008
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000009
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000010
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000011
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000012
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000013
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000014
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000015
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000016
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000017
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000018
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000019
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000020
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000021
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000022
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000023
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000024
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000025
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000026
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000027
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000028
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000029
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000030
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000031
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000032
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000033
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000034
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000035
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000036
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000037
    [Fri May  5 01:36:11 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000038
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000039
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000040
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000041
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000042
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000043
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000044
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000045
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000046
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000047
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000048
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000049
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000050
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000051
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000052
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000053
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000054
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000055
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000056
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000057
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000058
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000059
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000060
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000061
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000062
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000063
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000064
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000065
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000066
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000067
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000068
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000069
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000070
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000071
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000072
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000073
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000074
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000075
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000076
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000077
    [Fri May  5 01:36:12 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000078
    [Fri May  5 01:36:12 EDT 2023] Backup saved to /home/mysqlbackup/binlog/050523-013610
    [Fri May  5 01:36:12 EDT 2023] Master Info Copied To: /home/mysqlbackup/binlog/050523-013610/master_info.log
    [Fri May  5 01:36:12 EDT 2023] Backup size: 1080 KB
    [Fri May  5 01:36:12 EDT 2023] Binlog Backup log file generated: /var/log/mysql_binlog_backup_050523-013610.log
    

    Code (Text):
    Vhost Backup Directory: /home/databackup/050523-013602
    MySQL Backup Directory: /home/mysqlbackup/mysql/050523-013610
    Binlog Backup Directory: /home/mysqlbackup/binlog/050523-013610
    
    Do you want to transfer the backup directories to remote server via SSH? [y/n/exit]: y
    Remote server SSH port (default: 22): 22
    Remote server SSH username (default: root): root
    Remote server SSH hostname/IP address: 123.123.123.123
    Tunnel method (nc or socat, default: nc): nc
    Buffer size for socat (in bytes, e.g., 131072 for 128 KB): 262144
    Listen port for nc or socat (default: 12345): 12345
    Remote (destination) backup directory: /home/remotebackup
    Path to the SSH private key: /root/.ssh/my1.key
    
    Transfer /home/mysqlbackup/mysql/050523-013610 Directory Data To Remote Server Via SSH
    
    Do you want to continue [y/n]: y
    /usr/local/src/centminmod/datamanagement/tunnel-transfers.sh -p 22 -u root -h 123.123.123.123 -m nc -b 262144 -l 12345 -s /home/mysqlbackup/mysql/050523-013610 -r /home/remotebackup/mysql -k /root/.ssh/my1.key
    Transfer completed successfully
    
    Transfer /home/databackup/050523-013602 Directory Data To Remote Server Via SSH
    
    Do you want to continue [y/n]: y
    /usr/local/src/centminmod/datamanagement/tunnel-transfers.sh -p 22 -u root -h 123.123.123.123 -m nc -b 262144 -l 12345 -s /home/databackup/050523-013602 -r /home/remotebackup/vhosts -k /root/.ssh/my1.key
    Transfer completed successfully
    
    Transfer /home/mysqlbackup/binlog/050523-013610 Directory Data To Remote Server Via SSH
    
    Do you want to continue [y/n]: y
    /usr/local/src/centminmod/datamanagement/tunnel-transfers.sh -p 22 -u root -h 123.123.123.123 -m nc -b 262144 -l 12345 -s /home/mysqlbackup/binlog/050523-013610 -r /home/remotebackup/mysql-binlogs -k /root/.ssh/my1.key
    Transfer completed successfully
    

    Remote server directory's contents
    Code (Text):
    ls -lAh /home/remotebackup/
    total 20K
    drwxr-xr-x 5 mysql mysql 4.0K May  5 01:36 mysql
    drwxr-xr-x 2 mysql mysql  12K May  5 01:36 mysql-binlogs
    drwxr-xr-x 2 root  root  4.0K May  5 01:36 vhosts
    

    Code (Text):
    ls -lAh /home/remotebackup/vhosts/
    total 243M
    -rw-r--r-- 1 root root 241M May  5 01:36 centminmod_backup.tar.zst
    -rw-r--r-- 1 root root 1.5M May  5 01:36 files-backup_050523-013602.log
    

    Code (Text):
    ls -lAh /home/remotebackup/mysql
    total 520K
    -rw-r--r-- 1 root  root  489K May  5 01:36 master_data.sql
    -rw-r--r-- 1 root  root  1.4K May  5 01:36 master_info.log
    drwxr-xr-x 2 mysql mysql 4.0K May  5 01:36 mysql
    -rwxr-xr-x 1 root  root  9.1K May  5 01:36 restore.sh
    drwxr-xr-x 2 mysql mysql 4.0K May  5 01:36 sakila
    drwxr-xr-x 2 mysql mysql 4.0K May  5 01:36 wp3233312196db_24171
    

    Code (Text):
    ls -lAh /home/remotebackup/mysql-binlogs/
    total 1.1M
    -rw-r--r-- 1 root root 1.5K May  5 01:36 master_info.log
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000001.sha256
    -rw-r--r-- 1 root root  221 May  5 01:36 mysql-bin.000001.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000002.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000002.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000003.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000003.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000004.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000004.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000005.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000005.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000006.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000006.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000007.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000007.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000008.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000008.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000009.sha256
    -rw-r--r-- 1 root root  261 May  5 01:36 mysql-bin.000009.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000010.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000010.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000011.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000011.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000012.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000012.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000013.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000013.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000014.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000014.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000015.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000015.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000016.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000016.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000017.sha256
    -rw-r--r-- 1 root root  260 May  5 01:36 mysql-bin.000017.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000018.sha256
    -rw-r--r-- 1 root root 169K May  5 01:36 mysql-bin.000018.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000019.sha256
    -rw-r--r-- 1 root root  17K May  5 01:36 mysql-bin.000019.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000020.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000020.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000021.sha256
    -rw-r--r-- 1 root root  273 May  5 01:36 mysql-bin.000021.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000022.sha256
    -rw-r--r-- 1 root root  273 May  5 01:36 mysql-bin.000022.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000023.sha256
    -rw-r--r-- 1 root root  273 May  5 01:36 mysql-bin.000023.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000024.sha256
    -rw-r--r-- 1 root root  273 May  5 01:36 mysql-bin.000024.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000025.sha256
    -rw-r--r-- 1 root root  273 May  5 01:36 mysql-bin.000025.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000026.sha256
    -rw-r--r-- 1 root root  11K May  5 01:36 mysql-bin.000026.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000027.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000027.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000028.sha256
    -rw-r--r-- 1 root root  268 May  5 01:36 mysql-bin.000028.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000029.sha256
    -rw-r--r-- 1 root root  275 May  5 01:36 mysql-bin.000029.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000030.sha256
    -rw-r--r-- 1 root root  32K May  5 01:36 mysql-bin.000030.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000031.sha256
    -rw-r--r-- 1 root root 9.9K May  5 01:36 mysql-bin.000031.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000032.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000032.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000033.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000033.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000034.sha256
    -rw-r--r-- 1 root root  266 May  5 01:36 mysql-bin.000034.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000035.sha256
    -rw-r--r-- 1 root root  235 May  5 01:36 mysql-bin.000035.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000036.sha256
    -rw-r--r-- 1 root root  545 May  5 01:36 mysql-bin.000036.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000037.sha256
    -rw-r--r-- 1 root root  275 May  5 01:36 mysql-bin.000037.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000038.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000038.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000039.sha256
    -rw-r--r-- 1 root root  275 May  5 01:36 mysql-bin.000039.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000040.sha256
    -rw-r--r-- 1 root root  275 May  5 01:36 mysql-bin.000040.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000041.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000041.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000042.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000042.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000043.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000043.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000044.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000044.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000045.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000045.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000046.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000046.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000047.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000047.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000048.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000048.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000049.sha256
    -rw-r--r-- 1 root root  275 May  5 01:36 mysql-bin.000049.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000050.sha256
    -rw-r--r-- 1 root root  275 May  5 01:36 mysql-bin.000050.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000051.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000051.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000052.sha256
    -rw-r--r-- 1 root root  11K May  5 01:36 mysql-bin.000052.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000053.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000053.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000054.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000054.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000055.sha256
    -rw-r--r-- 1 root root 2.0K May  5 01:36 mysql-bin.000055.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000056.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000056.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000057.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000057.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000058.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000058.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000059.sha256
    -rw-r--r-- 1 root root 176K May  5 01:36 mysql-bin.000059.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000060.sha256
    -rw-r--r-- 1 root root  10K May  5 01:36 mysql-bin.000060.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000061.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000061.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000062.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000062.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000063.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000063.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000064.sha256
    -rw-r--r-- 1 root root  22K May  5 01:36 mysql-bin.000064.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000065.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000065.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000066.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000066.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000067.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000067.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000068.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000068.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000069.sha256
    -rw-r--r-- 1 root root 9.8K May  5 01:36 mysql-bin.000069.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000070.sha256
    -rw-r--r-- 1 root root  275 May  5 01:36 mysql-bin.000070.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000071.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000071.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000072.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000072.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000073.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000073.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000074.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000074.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000075.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000075.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000076.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000076.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000077.sha256
    -rw-r--r-- 1 root root  274 May  5 01:36 mysql-bin.000077.zst
    -rw-r--r-- 1 root root  122 May  5 01:36 mysql-bin.000078.sha256
    -rw-r--r-- 1 root root  243 May  5 01:36 mysql-bin.000078.zst