I have my mysql master server fails with disk failure. I was doing mysql backup using pmm and sending them to my s3 server.
I used a “full” backup.
Now i set up a new mysql server clean and running (apt-get install mysql, mysql_secure_installation) and so on. Now i want to restore my backup (xtrabackup binary file have the same version as in mysql master server), but it fails.
Here is my command:
xtrabackup --prepare --target-dir=/var/tmp/minio/mysql-master-backup-full_2023-10-22T00:00:00Z and here is an output
xtrabackup version 2.3.10 based on MySQL server 5.6.24 Linux (x86_64) (revision id: bd0d4403f36) xtrabackup: cd to /var/tmp/minio/mysql-master-backup-full_2023-10-22T00:00:00Z/ xtrabackup: Error: cannot open ./xtrabackup_checkpoints xtrabackup: Error: failed to read metadata from './xtrabackup_checkpoints'
What is more - i havent
xtrabackup_checkpoints file here, just something like this
ls -l | grep xtra -rw-r--r-- 1 root root 172 Oct 22 20:33 xtrabackup_binlog_info.qp.00000000000000000000 -rw-r--r-- 1 root root 39 Oct 22 20:33 xtrabackup_binlog_info.qp.00000000000000000001 -rw-r--r-- 1 root root 150 Oct 22 21:02 xtrabackup_checkpoints.00000000000000000000 -rw-r--r-- 1 root root 36 Oct 22 20:33 xtrabackup_checkpoints.00000000000000000001 -rw-r--r-- 1 root root 636 Oct 22 20:33 xtrabackup_info.qp.00000000000000000000 -rw-r--r-- 1 root root 32 Oct 22 20:33 xtrabackup_info.qp.00000000000000000001 -rw-r--r-- 1 root root 1418101 Oct 22 20:33 xtrabackup_logfile.qp.00000000000000000000 -rw-r--r-- 1 root root 35 Oct 22 20:33 xtrabackup_logfile.qp.00000000000000000001
Also when i am using
cat *checkpoints there is also some corrupted text like this
XBSTCK01Extrabackup_checkpointsbackup_type = full-backuped from_lsn = 0 to_lsn = 114023178266 last_lsn = 114027601203 compact = 0 recover_binlog_info = 0 flushed_lsn = 114027339420
Also if this important for example inside database folders i have files like this
and so on
I really need your help, because this is a very important production server and i do not want to loose all of my data. Please