Dear Concerned,
I have do R & D in mysql 8.0.22 in Debain 10 and using xtrabackup for full and incremental mysql backup and download the scripts from some sites . In that they are using innobackupex but it is not available in Debian 10 (x86_64) .
-
How to take full backup
-
Take incremental backup
-
Take the full backup from remote machine to local machine
-
Resote the full and incremental backup in another instance
Could you please help to me in this case, it would be great
2 Likes
Hey @gopalakrishna99 ,
Innobackupex was a wrapper for xtrabackup. It has been deprecated in 2.4 and removed from 8.0. You should use xtrabackup binary instead.
Regarding your questions:
- The Backup Cycle - Full Backups - Percona XtraBackup
- Incremental Backup - Percona XtraBackup
- This is not possible. PXB requires local access to the database files.
- Just check the restore part from the documentation on point 1 / 2 . Here will be the same. You can move the files after the backup to the destination instance, and prepare the files there.
1 Like
Thanks for replying for innobackupex information
1 Like