-
Type:
Bug
-
Status: Done
-
Priority:
Low
-
Resolution: Fixed
-
Affects Version/s: 8.0.7
-
Fix Version/s: 8.0.7
-
Component/s: None
-
Labels:None
Take full backup
./xtrabackup --user=root --password='' --backup --target-dir=$HOME/dbbackup_PS8/full -S $HOME/PS230719_8_0_16_6_debug/socket.sock --datadir=$HOME/PS230719_8_0_16_6_debug/data --compress=lz4 --compress-threads=10 --parallel=10 --keyring_file_data=$HOME/PS230719_8_0_16_6_debug/keyring --xtrabackup-plugin-dir=$HOME/pxb_8_0_7_debug/lib/plugin 2>full_backup_$(date +"%d_%m_%Y")_log
Decompress the backup
./xtrabackup --decompress --parallel=10 --target-dir=$HOME/dbbackup_PS8/full 2>decompressfullbackuplog
Prepare the backup
./xtrabackup --prepare --target_dir=$HOME/dbbackup_PS8/full --keyring_file_data=$HOME/PS230719_8_0_16_6_debug/keyring --xtrabackup-plugin-dir=$HOME/pxb_8_0_7_debug/lib/plugin 2>&1 | tee prepare_full_backup_$(date +"%d_%m_%Y")_log
Restore the backup
./xtrabackup --copy-back --target-dir=$HOME/dbbackup_PS8/full --datadir=$HOME/PS230719_8_0_16_6_debug/data --keyring_file_data=$HOME/PS230719_8_0_16_6_debug/keyring --xtrabackup-plugin-dir=$HOME/pxb_8_0_7_debug/lib/plugin 2>&1 | tee restore_full_backup_$(date +"%d_%m_%Y")_log
After the restore, the data dir contains the compressed lz4 files also
-rw-r----- 1 mchawla mchawla 12582912 Jul 29 13:12 undo_001 -rw-r----- 1 mchawla mchawla 12582912 Jul 29 13:12 undo_002 -rw-r----- 1 mchawla mchawla 50331648 Jul 29 13:12 ib_logfile0 -rw-r----- 1 mchawla mchawla 50331648 Jul 29 13:12 ib_logfile1 -rw-r----- 1 mchawla mchawla 12582912 Jul 29 13:12 ibdata1 -rw-r----- 1 mchawla mchawla 515 Jul 29 13:12 binlog.000030 -rw-r----- 1 mchawla mchawla 16 Jul 29 13:12 binlog.index -rw-r----- 1 mchawla mchawla 424 Jul 29 13:12 backup-my.cnf.lz4 -rw-r----- 1 mchawla mchawla 329 Jul 29 13:12 binlog.000030.lz4 -rw-r----- 1 mchawla mchawla 869 Jul 29 13:12 xtrabackup_info.lz4 -rw-r----- 1 mchawla mchawla 45 Jul 29 13:12 binlog.index.lz4 -rw-r----- 1 mchawla mchawla 190 Jul 29 13:12 xtrabackup_tablespaces.lz4 -rw-r----- 1 mchawla mchawla 1230 Jul 29 13:12 ib_buffer_pool.lz4 -rw-r----- 1 mchawla mchawla 3510 Jul 29 13:12 ib_buffer_pool drwxr-x--- 2 mchawla mchawla 4096 Jul 29 13:12 sys -rw-r----- 1 mchawla mchawla 24117248 Jul 29 13:12 mysql.ibd drwxr-x--- 2 mchawla mchawla 4096 Jul 29 13:12 mysql drwxr-x--- 2 mchawla mchawla 4096 Jul 29 13:12 test -rw-r----- 1 mchawla mchawla 306 Jul 29 13:12 xtrabackup_binlog_info.lz4 drwxr-x--- 2 mchawla mchawla 16384 Jul 29 13:12 performance_schema -rw-r----- 1 mchawla mchawla 12582912 Jul 29 13:12 ibtmp1 drwxr-x--- 2 mchawla mchawla 4096 Jul 29 13:12 test_rocksdb -rw-r----- 1 mchawla mchawla 513 Jul 29 13:12 xtrabackup_logfile.lz4 -rw-r----- 1 mchawla mchawla 2055352 Jul 29 13:12 mysql.ibd.lz4 -rw-r----- 1 mchawla mchawla 1214 Jul 29 13:12 xtrabackup_info -rw-r----- 1 mchawla mchawla 18 Jul 29 13:12 xtrabackup_binlog_pos_innodb -rw-r----- 1 mchawla mchawla 1 Jul 29 13:12 xtrabackup_master_key_id
Though the database is able to come up successfully, the compressed files can be ignored while copying the data files in the data directory.