hi,
I am not a linux guy and when I do df -h I see this:
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 59G 9.8G 47G 18% /
tmpfs 3.9G 0 3.9G 0% /dev/shm
/dev/mapper/rhel-mysql
197G 159G 29G 85% /mysql
The problem now is , I want to do mysqldump and that dump .sql is so large that my existing volumn, can’t store it !
is the default volumn in redhat linux is /dev/sda1 , which is mount on / ?
how can I use /mysql as the backup volumn ?
I read this: https://serverfault.com/questions/804270/how-to-compress-this-mysqldump
or what is the correct command for me to zip the mysqldump file so that I can restore to xtraDB cluster 8.0.19 ?
and what is the correct command to restore the zip files to xtraDB cluster 8.0.19 ?
I would suggest having a separate backup server to store your backups and then use Percona XtraBackup to stream the backup from your existing database server host to the backup server host. You will find the instructions on how to stream backups here:Make a Streaming Backup - Percona XtraBackup