Beta Branch prep for new centmin.sh menu option 21 submenu routine in 130.00beta01

prep for new centmin.sh menu option 21 submenu routine in 130.00beta01

This work is intended for when CentOS 7 to AlmaLinux 8 or Rocky Linux 8 data migration routines are finalised

Continue reading...

---

130.00beta01 branch

• Branch: GitHub - centminmod/centminmod at 130.00beta01
• Commit History: Commits · centminmod/centminmod

Support Centmin Mod

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

 

Work on centmin.sh menu option 21 is still in private development but here's a preview Don't forget to support Centmin Mod https://community.centminmod.com/threads/ways-to-support-centmin-mod.11435/

Code (Text):

--------------------------------------------------------
     Centmin Mod Menu 130.00beta01 centminmod.com  
--------------------------------------------------------
1).  Centmin Install
2).  Add Nginx vhost domain
3).  NSD setup domain name DNS
4).  Nginx Upgrade / Downgrade
5).  PHP Upgrade / Downgrade
6).  Option Being Revised (TBA)
7).  Option Being Revised (TBA)
8).  Option Being Revised (TBA)
9).  Option Being Revised (TBA)
10). Memcached Server Re-install
11). MariaDB MySQL Upgrade & Management
12). Zend OpCache Install/Re-install
13). Install/Reinstall Redis PHP Extension
14). SELinux disable
15). Install/Reinstall ImagicK PHP Extension
16). Change SSHD Port Number
17). Multi-thread compression: zstd,pigz,pbzip2,lbzip2
18). Suhosin PHP Extension install
19). Install FFMPEG and FFMPEG PHP Extension
20). NSD Install/Re-Install
21). Data Transfer (TBA)
22). Add Wordpress Nginx vhost + Cache Plugin
23). Update Centmin Mod Code Base
24). Exit
--------------------------------------------------------
Enter option [ 1 - 24 ] 21
--------------------------------------------------------

Code (Text):

--------------------------------------------------------
     Centmin Mod Data Management    
--------------------------------------------------------
1).  Migrate Centmin Mod Data To New Centmin Mod Server
2).  Backup Nginx Vhosts Data + MariaBackup MySQL Backups
3).  Backup Nginx Vhosts Data Only (no MariaDB MySQL backups)
4).  Backup MariaDB MySQL With MariaBackup Only (no Vhosts Data backups)
5).  Backup MariaDB MySQL With mysqldump only (no Vhosts Data backups)
6).  Transfer Directory Data To Remote Server Via SSH
7).  Transfer Directory Data To S3 Compatible Storage
8).  Transfer Files To S3 Compatible Storage
9).  Download S3 Compatible Stored Data To Server
10). S3 To S3 Compatible Storage Transfers
11). List S3 Storage Buckets
12). Back to Main menu
--------------------------------------------------------
Enter option [ 1 - 11 ] 2
--------------------------------------------------------

menu option 21 submenu option 2 with tar + zstd

Code (Text):

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
[Tue May  2 20:54:13 EDT 2023] Total uncompressed size of all directories to be backed up: 107.97MB
[Tue May  2 20:54:13 EDT 2023] Free space available on /home: 16.89GB
[Tue May  2 20:54:13 EDT 2023] Creating temporary domain data directory ...
[Tue May  2 20:54:13 EDT 2023] Copying domain data (excluding logs) ...
[Tue May  2 20:54:15 EDT 2023] Creating temporary MariaDB data directory ...
[Tue May  2 20:54:15 EDT 2023] Performing MariaBackup To /home/databackup/020523-205413/mariadb_tmp ...
[Tue May  2 20:54:17 EDT 2023] Preparing MariaBackup At /home/databackup/020523-205413/mariadb_tmp ...
[Tue May  2 20:54:18 EDT 2023] /home/databackup/020523-205413/mariadb_tmp/mariabackup-restore.sh saved
[Tue May  2 20:54:18 EDT 2023] MariaBackup log saved at /home/databackup/020523-205413/mariadb_tmp/mariabackup_020523-205413.log
[Tue May  2 20:54:18 EDT 2023] Creating backup tarball using zstd compression (-T2 --fast=4)
[Tue May  2 20:54:21 EDT 2023] Cleaning up temporary directories ...
[Tue May  2 20:54:21 EDT 2023] Backup completed. File: /home/databackup/020523-205413/centminmod_backup.tar.zst
[Tue May  2 20:54:21 EDT 2023] Backup Log saved:
[Tue May  2 20:54:21 EDT 2023] Script execution time: 8 seconds

Code (Text):

ls -lAhrt /home/databackup/020523-205413
total 126M
-rw-r--r-- 1 root root 126M May  2 20:54 centminmod_backup.tar.zst

menu option 21 submenu option 2 without tar + zstd (uncompressed)

Code (Text):

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]: n
[Tue May  2 21:01:27 EDT 2023] Total uncompressed size of all directories to be backed up: 107.97MB
[Tue May  2 21:01:27 EDT 2023] Free space available on /home: 16.77GB
[Tue May  2 21:01:27 EDT 2023] Creating temporary domain data directory ...
[Tue May  2 21:01:27 EDT 2023] Copying domain data (excluding logs) ...
[Tue May  2 21:01:29 EDT 2023] Creating temporary MariaDB data directory ...
[Tue May  2 21:01:29 EDT 2023] Performing MariaBackup To /home/databackup/020523-210127/mariadb_tmp ...
[Tue May  2 21:01:32 EDT 2023] Preparing MariaBackup At /home/databackup/020523-210127/mariadb_tmp ...
[Tue May  2 21:01:32 EDT 2023] /home/databackup/020523-210127/mariadb_tmp/mariabackup-restore.sh saved
[Tue May  2 21:01:32 EDT 2023] MariaBackup log saved at /home/databackup/020523-210127/mariadb_tmp/mariabackup_020523-210127.log
[Tue May  2 21:01:32 EDT 2023] Backup completed at /home/databackup/020523-210127
[Tue May  2 21:01:32 EDT 2023] Backup Log saved: /home/databackup/020523-210127/files-backup_020523-210127.log
[Tue May  2 21:01:33 EDT 2023] Script execution time: 5 seconds

Code (Text):

ls -lAhrt /home/databackup/020523-210127
total 304K
drwxr-xr-x 7 root root 4.0K May  2 21:01 domains_tmp
drwxr-xr-x 6 root root 4.0K May  2 21:01 mariadb_tmp
-rw-r--r-- 1 root root 295K May  2 21:01 files-backup_020523-210127.log

uncompressed Nginx vhost data files

Code (Text):

ls -lAhrt /home/databackup/020523-210127/domains_tmp/
total 272K
drwxr-x--- 6 nginx nginx 4.0K Nov 24 18:26 demodomain.com
drwxr-s--- 6 nginx nginx 4.0K Dec 10 02:00 domain1.com
drwxr-s--- 8 nginx nginx 4.0K Dec 17 03:21 domain2.com
drwxr-s--- 6 nginx nginx 4.0K Feb 17 02:29 domain3.com
drwxr-s--- 6 nginx nginx 4.0K Apr  6 18:10 log4j.domain.com
-rw-r--r-- 1 root  root  250K May  2 21:01 rsync_020523-210127.log

uncompressed MariaDB MySQL backups created with MariaBackup tool. This server had MySQL binary logging enabled so mysql-bin.* binary logs are backed up too. A mariabackup-restore.sh script is saved too used to restore the MariaDB MySQL data.

Code (Text):

ls -lAhrt /home/databackup/020523-210127/mariadb_tmp/
total 77M
-rwxr-xr-x 1 root root 3.9K May  2 06:19 mariabackup-restore.sh
drwx------ 2 root root 4.0K May  2 21:01 sakila
drwx------ 2 root root 4.0K May  2 21:01 mysql
drwx------ 2 root root 4.0K May  2 21:01 wp3233312196db_24171
drwx------ 2 root root 4.0K May  2 21:01 performance_schema
-rw-r----- 1 root root   52 May  2 21:01 aria_log_control
-rw-r----- 1 root root  16K May  2 21:01 aria_log.00000001
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000002
-rw-r----- 1 root root  375 May  2 21:01 mysql-bin.000001
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000007
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000006
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000005
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000004
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000003
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000012
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000011
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000010
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000009
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000008
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000016
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000015
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000014
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000013
-rw-r----- 1 root root 589K May  2 21:01 mysql-bin.000018
-rw-r----- 1 root root  418 May  2 21:01 mysql-bin.000017
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000020
-rw-r----- 1 root root 489K May  2 21:01 mysql-bin.000019
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000024
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000023
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000022
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000021
-rw-r----- 1 root root 265K May  2 21:01 mysql-bin.000026
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000025
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000029
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000028
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000027
-rw-r----- 1 root root 132K May  2 21:01 mysql-bin.000030
-rw-r----- 1 root root 204K May  2 21:01 mysql-bin.000031
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000037
-rw-r----- 1 root root 1.1K May  2 21:01 mysql-bin.000036
-rw-r----- 1 root root  389 May  2 21:01 mysql-bin.000035
-rw-r----- 1 root root  408 May  2 21:01 mysql-bin.000034
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000033
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000032
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000042
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000041
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000040
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000039
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000038
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000047
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000046
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000045
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000044
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000043
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000050
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000049
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000048
-rw-r----- 1 root root 265K May  2 21:01 mysql-bin.000052
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000051
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000056
-rw-r----- 1 root root  16K May  2 21:01 mysql-bin.000055
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000054
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000053
-rw-r----- 1 root root  385 May  2 21:01 mysql-bin.000058
-rw-r----- 1 root root  432 May  2 21:01 mysql-bin.000057
-rw-r----- 1 root root 1.4K May  2 21:01 xtrabackup_binlog_info
-rw-r----- 1 root root  581 May  2 21:01 xtrabackup_info
-rw-r----- 1 root root 4.1K May  2 21:01 ib_buffer_pool
-rw-r----- 1 root root  325 May  2 21:01 backup-my.cnf
-rw-r----- 1 root root  74M May  2 21:01 ibdata1
-rw-r----- 1 root root    0 May  2 21:01 ib_logfile0
-rw-r----- 1 root root   79 May  2 21:01 xtrabackup_checkpoints
-rw-r--r-- 1 root root  45K May  2 21:01 mariabackup_020523-210127.log

 

example for menu option 21 submenu option 5 for mysqldump based MySQL backups

Code (Text):

--------------------------------------------------------
     Centmin Mod Data Management      
--------------------------------------------------------
1).  Migrate Centmin Mod Data To New Centmin Mod Server
2).  Backup Nginx Vhosts Data + MariaBackup MySQL Backups
3).  Backup Nginx Vhosts Data Only (no MariaDB MySQL backups)
4).  Backup MariaDB MySQL With MariaBackup Only (no Vhosts Data backups)
5).  Backup MariaDB MySQL With mysqldump only (no Vhosts Data backups)
6).  Transfer Directory Data To Remote Server Via SSH
7).  Transfer Directory Data To S3 Compatible Storage
8).  Transfer Files To S3 Compatible Storage
9).  Download S3 Compatible Stored Data To Server
10). S3 To S3 Compatible Storage Transfers
11). List S3 Storage Buckets
12). Back to Main menu
--------------------------------------------------------
Enter option [ 1 - 11 ] 5
--------------------------------------------------------

Code (Text):

Backup MariaDB MySQL With mysqldump only (no Vhosts Data backups)

Description:
This option is for MariaDB MySQL database backups only using mysqldump native
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 to continue [y/n]: y
[Tue May  2 21:22:54 EDT 2023] backup database: mysql (1.38281 MB)
[Tue May  2 21:22:54 EDT 2023] backup time for mysql: 0.03s
[Tue May  2 21:22:54 EDT 2023] backup database: sakila (23.8555 MB)
[Tue May  2 21:22:54 EDT 2023] backup time for sakila: 0.16s
[Tue May  2 21:22:54 EDT 2023] backup database: wp3233312196db_24171 (11.543 MB)
[Tue May  2 21:22:55 EDT 2023] backup time for wp3233312196db_24171: 0.03s

[Tue May  2 21:22:55 EDT 2023] MySQL backup completed. MASTER_LOG_FILE and MASTER_LOG_POS: mysql-bin.000059,342
[Tue May  2 21:22:55 EDT 2023] Restore script generated: /home/mysqlbackup/mysql/020523-212254/restore.sh
[Tue May  2 21:22:55 EDT 2023] Master Info log generated: /home/mysqlbackup/mysql/020523-212254/master_info.log
[Tue May  2 21:22:55 EDT 2023] Backup log file generated: /var/log/mysql_backup_020523-212254.log
[Tue May  2 21:22:55 EDT 2023] Backup size: 2524 KB
[Tue May  2 21:22:55 EDT 2023] Backup saved to /home/mysqlbackup/mysql/020523-212254

[Tue May  2 21:22:55 EDT 2023] Starting binlog backup process...
[Tue May  2 21:22:55 EDT 2023] Total size of mysql-bin files: 1.93223 MB
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000001
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000002
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000003
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000004
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000005
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000006
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000007
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000008
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000009
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000010
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000011
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000012
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000013
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000014
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000015
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000016
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000017
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000018
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000019
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000020
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000021
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000022
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000023
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000024
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000025
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000026
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000027
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000028
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000029
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000030
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000031
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000032
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000033
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000034
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000035
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000036
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000037
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000038
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000039
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000040
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000041
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000042
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000043
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000044
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000045
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000046
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000047
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000048
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000049
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000050
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000051
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000052
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000053
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000054
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000055
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000056
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000057
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000058
[Tue May  2 21:22:55 EDT 2023] backup binlog /var/lib/mysql//mysql-bin.000059
[Tue May  2 21:22:55 EDT 2023] Backup to /home/mysqlbackup/binlog/020523-212254 completed.
[Tue May  2 21:22:55 EDT 2023] Master Info Copied To: /home/mysqlbackup/binlog/020523-212254/master_info.log
[Tue May  2 21:22:55 EDT 2023] Backup size: 712 KB
[Tue May  2 21:22:55 EDT 2023] Binlog Backup log file generated: /var/log/mysql_binlog_backup_020523-212254.log

mysqldump uses --tab delimited method and splits MySQL data and binlog backups to their own directories

Code (Text):

ls -lAh /home/mysqlbackup
total 8.0K
drwxr-xr-x 13 mysql mysql 4.0K May  2 21:22 binlog
drwxr-xr-x 13 mysql mysql 4.0K May  2 21:22 mysql

Code (Text):

ls -lAh /home/mysqlbackup/mysql
total 44K
drwxr-xr-x 2 mysql mysql 4.0K May  2 10:51 020523-105123
drwxr-xr-x 5 mysql mysql 4.0K May  2 10:51 020523-105137
drwxr-xr-x 2 mysql mysql 4.0K May  2 10:51 020523-105144
drwxr-xr-x 2 mysql mysql 4.0K May  2 10:51 020523-105151
drwxr-xr-x 2 mysql mysql 4.0K May  2 10:56 020523-105600
drwxr-xr-x 2 mysql mysql 4.0K May  2 10:59 020523-105954
drwxr-xr-x 2 mysql mysql 4.0K May  2 19:27 020523-192705
drwxr-xr-x 2 mysql mysql 4.0K May  2 20:50 020523-205000
drwxr-xr-x 2 mysql mysql 4.0K May  2 20:54 020523-205413
drwxr-xr-x 2 mysql mysql 4.0K May  2 21:01 020523-210127
drwxr-xr-x 5 mysql mysql 4.0K May  2 21:22 020523-212254

Code (Text):

ls -lAh /home/mysqlbackup/binlog/
total 44K
drwxr-xr-x 2 mysql mysql 4.0K May  2 10:51 020523-105123
drwxr-xr-x 2 mysql mysql 4.0K May  2 10:51 020523-105137
drwxr-xr-x 2 mysql mysql 4.0K May  2 10:51 020523-105144
drwxr-xr-x 2 mysql mysql 4.0K May  2 10:51 020523-105151
drwxr-xr-x 2 mysql mysql 4.0K May  2 10:56 020523-105600
drwxr-xr-x 2 mysql mysql 4.0K May  2 10:59 020523-105954
drwxr-xr-x 2 mysql mysql 4.0K May  2 19:27 020523-192705
drwxr-xr-x 2 mysql mysql 4.0K May  2 20:50 020523-205000
drwxr-xr-x 2 mysql mysql 4.0K May  2 20:54 020523-205413
drwxr-xr-x 2 mysql mysql 4.0K May  2 21:01 020523-210127
drwxr-xr-x 2 mysql mysql 4.0K May  2 21:22 020523-212254

MySQL database backups with mysqldump --tab delimited method

Code (Text):

ls -lAh /home/mysqlbackup/mysql/020523-212254
total 520K
-rw-r--r-- 1 root  root  489K May  2 21:22 master_data.sql
-rw-r--r-- 1 root  root  1.1K May  2 21:22 master_info.log
drwxr-xr-x 2 mysql mysql 4.0K May  2 21:22 mysql
-rwxr-xr-x 1 root  root  9.1K May  2 21:22 restore.sh
drwxr-xr-x 2 mysql mysql 4.0K May  2 21:22 sakila
drwxr-xr-x 2 mysql mysql 4.0K May  2 21:22 wp3233312196db_24171

binary log backup run files

Code (Text):

ls -lAh /home/mysqlbackup/binlog/020523-212254
total 712K
-rw-r--r-- 1 root root 1.1K May  2 21:22 master_info.log
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000001.sha256
-rw-r--r-- 1 root root  221 May  2 21:22 mysql-bin.000001.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000002.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000002.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000003.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000003.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000004.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000004.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000005.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000005.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000006.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000006.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000007.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000007.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000008.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000008.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000009.sha256
-rw-r--r-- 1 root root  261 May  2 21:22 mysql-bin.000009.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000010.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000010.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000011.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000011.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000012.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000012.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000013.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000013.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000014.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000014.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000015.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000015.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000016.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000016.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000017.sha256
-rw-r--r-- 1 root root  260 May  2 21:22 mysql-bin.000017.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000018.sha256
-rw-r--r-- 1 root root 169K May  2 21:22 mysql-bin.000018.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000019.sha256
-rw-r--r-- 1 root root  17K May  2 21:22 mysql-bin.000019.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000020.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000020.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000021.sha256
-rw-r--r-- 1 root root  273 May  2 21:22 mysql-bin.000021.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000022.sha256
-rw-r--r-- 1 root root  273 May  2 21:22 mysql-bin.000022.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000023.sha256
-rw-r--r-- 1 root root  273 May  2 21:22 mysql-bin.000023.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000024.sha256
-rw-r--r-- 1 root root  273 May  2 21:22 mysql-bin.000024.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000025.sha256
-rw-r--r-- 1 root root  273 May  2 21:22 mysql-bin.000025.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000026.sha256
-rw-r--r-- 1 root root  11K May  2 21:22 mysql-bin.000026.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000027.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000027.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000028.sha256
-rw-r--r-- 1 root root  268 May  2 21:22 mysql-bin.000028.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000029.sha256
-rw-r--r-- 1 root root  275 May  2 21:22 mysql-bin.000029.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000030.sha256
-rw-r--r-- 1 root root  32K May  2 21:22 mysql-bin.000030.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000031.sha256
-rw-r--r-- 1 root root 9.9K May  2 21:22 mysql-bin.000031.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000032.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000032.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000033.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000033.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000034.sha256
-rw-r--r-- 1 root root  266 May  2 21:22 mysql-bin.000034.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000035.sha256
-rw-r--r-- 1 root root  235 May  2 21:22 mysql-bin.000035.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000036.sha256
-rw-r--r-- 1 root root  545 May  2 21:22 mysql-bin.000036.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000037.sha256
-rw-r--r-- 1 root root  275 May  2 21:22 mysql-bin.000037.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000038.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000038.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000039.sha256
-rw-r--r-- 1 root root  275 May  2 21:22 mysql-bin.000039.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000040.sha256
-rw-r--r-- 1 root root  275 May  2 21:22 mysql-bin.000040.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000041.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000041.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000042.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000042.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000043.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000043.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000044.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000044.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000045.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000045.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000046.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000046.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000047.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000047.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000048.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000048.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000049.sha256
-rw-r--r-- 1 root root  275 May  2 21:22 mysql-bin.000049.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000050.sha256
-rw-r--r-- 1 root root  275 May  2 21:22 mysql-bin.000050.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000051.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000051.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000052.sha256
-rw-r--r-- 1 root root  11K May  2 21:22 mysql-bin.000052.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000053.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000053.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000054.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000054.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000055.sha256
-rw-r--r-- 1 root root 2.0K May  2 21:22 mysql-bin.000055.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000056.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000056.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000057.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000057.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000058.sha256
-rw-r--r-- 1 root root  274 May  2 21:22 mysql-bin.000058.zst
-rw-r--r-- 1 root root  122 May  2 21:22 mysql-bin.000059.sha256
-rw-r--r-- 1 root root  243 May  2 21:22 mysql-bin.000059.zst

MySQL database = sakila backup folder with mysqldump --tab individual table *.sql and .txt files which can be restored via regenerated /home/mysqlbackup/mysql/020523-212254/restore.sh script

Code (Text):

ls -lAh /home/mysqlbackup/mysql/020523-212254/sakila/
total 1.3M
-rw-r--r-- 1 root  root  2.6K May  2 21:22 actor_info.sql
-rw-r--r-- 1 root  root  1.6K May  2 21:22 actor.sql
-rw-r--r-- 1 root  root   121 May  2 21:22 actor.txt.sha256
-rw-r--r-- 1 mysql mysql 2.9K May  2 21:22 actor.txt.zst
-rw-r--r-- 1 root  root  1.9K May  2 21:22 address.sql
-rw-r--r-- 1 root  root   123 May  2 21:22 address.txt.sha256
-rw-r--r-- 1 mysql mysql  31K May  2 21:22 address.txt.zst
-rw-r--r-- 1 root  root  1.5K May  2 21:22 category.sql
-rw-r--r-- 1 root  root   124 May  2 21:22 category.txt.sha256
-rw-r--r-- 1 mysql mysql  237 May  2 21:22 category.txt.zst
-rw-r--r-- 1 root  root  1.7K May  2 21:22 city.sql
-rw-r--r-- 1 root  root   120 May  2 21:22 city.txt.sha256
-rw-r--r-- 1 mysql mysql 8.6K May  2 21:22 city.txt.zst
-rw-r--r-- 1 root  root  1.5K May  2 21:22 country.sql
-rw-r--r-- 1 root  root   123 May  2 21:22 country.txt.sha256
-rw-r--r-- 1 mysql mysql 1.4K May  2 21:22 country.txt.zst
-rw-r--r-- 1 root  root  2.4K May  2 21:22 customer_list.sql
-rw-r--r-- 1 root  root  3.1K May  2 21:22 customer.sql
-rw-r--r-- 1 root  root   124 May  2 21:22 customer.txt.sha256
-rw-r--r-- 1 mysql mysql  17K May  2 21:22 customer.txt.zst
-rw-r--r-- 1 root  root  1.8K May  2 21:22 film_actor.sql
-rw-r--r-- 1 root  root   126 May  2 21:22 film_actor.txt.sha256
-rw-r--r-- 1 mysql mysql  25K May  2 21:22 film_actor.txt.zst
-rw-r--r-- 1 root  root  1.8K May  2 21:22 film_category.sql
-rw-r--r-- 1 root  root   129 May  2 21:22 film_category.txt.sha256
-rw-r--r-- 1 mysql mysql 5.0K May  2 21:22 film_category.txt.zst
-rw-r--r-- 1 root  root  2.5K May  2 21:22 film_list.sql
-rw-r--r-- 1 root  root  5.9K May  2 21:22 film.sql
-rw-r--r-- 1 root  root  1.5K May  2 21:22 film_text.sql
-rw-r--r-- 1 root  root   125 May  2 21:22 film_text.txt.sha256
-rw-r--r-- 1 mysql mysql  36K May  2 21:22 film_text.txt.zst
-rw-r--r-- 1 root  root   120 May  2 21:22 film.txt.sha256
-rw-r--r-- 1 mysql mysql  48K May  2 21:22 film.txt.zst
-rw-r--r-- 1 root  root  1.9K May  2 21:22 inventory.sql
-rw-r--r-- 1 root  root   125 May  2 21:22 inventory.txt.sha256
-rw-r--r-- 1 mysql mysql  17K May  2 21:22 inventory.txt.zst
-rw-r--r-- 1 root  root  1.5K May  2 21:22 language.sql
-rw-r--r-- 1 root  root   124 May  2 21:22 language.txt.sha256
-rw-r--r-- 1 mysql mysql  123 May  2 21:22 language.txt.zst
-rw-r--r-- 1 root  root  2.8K May  2 21:22 nicer_but_slower_film_list.sql
-rw-r--r-- 1 root  root  3.2K May  2 21:22 payment.sql
-rw-r--r-- 1 root  root   123 May  2 21:22 payment.txt.sha256
-rw-r--r-- 1 mysql mysql 338K May  2 21:22 payment.txt.zst
-rw-r--r-- 1 root  root  3.2K May  2 21:22 rental.sql
-rw-r--r-- 1 root  root   122 May  2 21:22 rental.txt.sha256
-rw-r--r-- 1 mysql mysql 436K May  2 21:22 rental.txt.zst
-rw-r--r-- 1 root  root   46K May  2 21:22 sakila-schema-only.sql
-rw-r--r-- 1 root  root   134 May  2 21:22 sakila-schema-only.sql.sha256
-rw-r--r-- 1 root  root  2.3K May  2 21:22 sales_by_film_category.sql
-rw-r--r-- 1 root  root  2.5K May  2 21:22 sales_by_store.sql
-rw-r--r-- 1 root  root  2.3K May  2 21:22 staff_list.sql
-rw-r--r-- 1 root  root  2.2K May  2 21:22 staff.sql
-rw-r--r-- 1 root  root   121 May  2 21:22 staff.txt.sha256
-rw-r--r-- 1 mysql mysql  35K May  2 21:22 staff.txt.zst
-rw-r--r-- 1 root  root  1.9K May  2 21:22 store.sql
-rw-r--r-- 1 root  root   121 May  2 21:22 store.txt.sha256
-rw-r--r-- 1 mysql mysql   50 May  2 21:22 store.txt.zst

/home/mysqlbackup/mysql/020523-212254/restore.sh script options allow you to restore all databases or individual ones unlike MariaBackup from submenu option 2, which can only do all databases backup/restore.

Code (Text):

/home/mysqlbackup/mysql/020523-212254/restore.sh
Usage:
/home/mysqlbackup/mysql/020523-212254/restore.sh all
/home/mysqlbackup/mysql/020523-212254/restore.sh mysql
/home/mysqlbackup/mysql/020523-212254/restore.sh sakila
/home/mysqlbackup/mysql/020523-212254/restore.sh wp3233312196db_24171

Example restoring a Wordpress database if same database name already exists, it restores to a new database with suffix _restorecopy_datetimestamp instead.

Code (Text):

/home/mysqlbackup/mysql/020523-212254/restore.sh wp3233312196db_24171

Checking if database exists: wp3233312196db_24171
Database already exists. Restoring to a new database: wp3233312196db_24171_restorecopy_20230502213305
/home/mysqlbackup/mysql/020523-212254/wp3233312196db_24171/19148_options.txt.zst: 86420 bytes 
/home/mysqlbackup/mysql/020523-212254/wp3233312196db_24171/19148_users.txt.zst: 202 bytes 
/home/mysqlbackup/mysql/020523-212254/wp3233312196db_24171/19148_term_relationships.txt.zst: 12 bytes 
/home/mysqlbackup/mysql/020523-212254/wp3233312196db_24171/19148_posts.txt.zst: 8449 bytes 
/home/mysqlbackup/mysql/020523-212254/wp3233312196db_24171/19148_comments.txt.zst: 348 bytes 
/home/mysqlbackup/mysql/020523-212254/wp3233312196db_24171/19148_links.txt.zst: 0 bytes 
/home/mysqlbackup/mysql/020523-212254/wp3233312196db_24171/19148_commentmeta.txt.zst: 0 bytes 
/home/mysqlbackup/mysql/020523-212254/wp3233312196db_24171/19148_termmeta.txt.zst: 0 bytes 
/home/mysqlbackup/mysql/020523-212254/wp3233312196db_24171/19148_usermeta.txt.zst: 1036 bytes 
/home/mysqlbackup/mysql/020523-212254/wp3233312196db_24171/19148_postmeta.txt.zst: 2327 bytes 
/home/mysqlbackup/mysql/020523-212254/wp3233312196db_24171/19148_terms.txt.zst: 32 bytes 
/home/mysqlbackup/mysql/020523-212254/wp3233312196db_24171/19148_term_taxonomy.txt.zst: 18 bytes 
wp3233312196db_24171_restorecopy_20230502213305.19148_commentmeta: Records: 0  Deleted: 0  Skipped: 0  Warnings: 0
wp3233312196db_24171_restorecopy_20230502213305.19148_links: Records: 0  Deleted: 0  Skipped: 0  Warnings: 0
wp3233312196db_24171_restorecopy_20230502213305.19148_comments: Records: 1  Deleted: 0  Skipped: 0  Warnings: 0
wp3233312196db_24171_restorecopy_20230502213305.19148_options: Records: 192  Deleted: 0  Skipped: 0  Warnings: 0
wp3233312196db_24171_restorecopy_20230502213305.19148_posts: Records: 8  Deleted: 0  Skipped: 0  Warnings: 0
wp3233312196db_24171_restorecopy_20230502213305.19148_postmeta: Records: 14  Deleted: 0  Skipped: 0  Warnings: 0
wp3233312196db_24171_restorecopy_20230502213305.19148_termmeta: Records: 0  Deleted: 0  Skipped: 0  Warnings: 0
wp3233312196db_24171_restorecopy_20230502213305.19148_term_relationships: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0
wp3233312196db_24171_restorecopy_20230502213305.19148_terms: Records: 1  Deleted: 0  Skipped: 0  Warnings: 0
wp3233312196db_24171_restorecopy_20230502213305.19148_term_taxonomy: Records: 1  Deleted: 0  Skipped: 0  Warnings: 0
wp3233312196db_24171_restorecopy_20230502213305.19148_usermeta: Records: 20  Deleted: 0  Skipped: 0  Warnings: 0
wp3233312196db_24171_restorecopy_20230502213305.19148_users: Records: 1  Deleted: 0  Skipped: 0  Warnings: 0

 

Follow up update https://community.centminmod.com/th...e-ssh-keys-s3-profiles-in-130-00beta01.23780/

 

FYI, you can follow all centmin.sh menu option 21 updates via forum tag = https://community.centminmod.com/tags/centminsh-menu-option-21/

 

Preview documentation for centmin.sh menu option 21 centminmod/centmin.sh-menu-21.readme.md at 130.00beta01 · centminmod/centminmod