Dear Sir.
I am new to mysqlbackup enterprise tool restore .
I ran the query for restore the tables table1 under schema schema1
mysqlbackup --socket=/data_log/mysql/mysql.sock --include-tables="^schema1 \.table1" --backup-dir=/data_log/bkptmp \
--backup-image=/xyz/fullbackup_20221217_2058.mbi copy-back-and-apply-log
The backup restore ran smoothly. It was a restore of single tables from the schema.
When I checked the table there was not a single record, in the tables table1.
I had deleted all the record from the table and truncated the table before restore.
The error message i got from dmesg is as follows:
[35400828.011371] dtrep: unsupported fallocate mode 3: srdhuser.ibd (177734082)
[35400828.107453] dtrep: unsupported fallocate mode 3: subaua_request_forward.ibd (177734084)
[35400828.107471] dtrep: unsupported fallocate mode 3: subaua_request_forward.ibd (177734084)
[35400828.159033] dtrep: unsupported fallocate mode 3: t_dept_scheme.ibd (177734086)
[35400828.159049] dtrep: unsupported fallocate mode 3: t_dept_scheme.ibd (177734086)
[35400828.178241] dtrep: unsupported fallocate mode 3: t_por_iptracking.ibd (177734088)
[35400828.178255] dtrep: unsupported fallocate mode 3: t_por_iptracking.ibd (177734088)
[35400828.271686] dtrep: unsupported fallocate mode 3: t_service_report.ibd (177734090)
[35400828.271714] dtrep: unsupported fallocate mode 3: t_service_report.ibd (177734090)
[35400828.300938] dtrep: unsupported fallocate mode 3: t_user.ibd (177734092)
[35400828.300953] dtrep: unsupported fallocate mode 3: t_user.ibd (177734092)
[35400828.349343] dtrep: unsupported fallocate mode 3: user_login_detail.ibd (177734094)
[35400828.349360] dtrep: unsupported fallocate mode 3: user_login_detail.ibd (177734094)
[35401224.339009] dtrep: unsupported fallocate mode 3: aadhaar_data_vault.ibd (177734098)
[35401224.339037] dtrep: unsupported fallocate mode 3: aadhaar_data_vault.ibd (177734098)
[35401224.389952] dtrep: unsupported fallocate mode 3: aadhaar_vault_service_log.ibd (177734100)
[35401224.389975] dtrep: unsupported fallocate mode 3: aadhaar_vault_service_log.ibd (177734100)
[35401226.824569] dtrep: unsupported fallocate mode 3: aadhar_vault_bulk_upload.ibd (177734102)
[35401226.824589] dtrep: unsupported fallocate mode 3: aadhar_vault_bulk_upload.ibd (177734102)
[35401226.950903] dtrep: unsupported fallocate mode 3: aadhar_vault_transaction.ibd (177734104)
[35401226.950921] dtrep: unsupported fallocate mode 3: aadhar_vault_transaction.ibd (177734104)
[35401227.127655] dtrep: unsupported fallocate mode 3: m_dept_scheme_vault.ibd (177734106)
[35401227.127671] dtrep: unsupported fallocate mode 3: m_dept_scheme_vault.ibd (177734106)
[35401227.165703] dtrep: unsupported fallocate mode 3: m_sub_aua_vault_details.ibd (177734108)
[35401227.165727] dtrep: unsupported fallocate mode 3: m_sub_aua_vault_details.ibd (177734108)
[35401227.200700] dtrep: unsupported fallocate mode 3: vault_count.ibd (177734110)
[35401227.200724] dtrep: unsupported fallocate mode 3: vault_count.ibd (177734110)
[35401227.242620] dtrep: unsupported fallocate mode 3: vault_storage_details.ibd (177734112)
[35401227.242641] dtrep: unsupported fallocate mode 3: vault_storage_details.ibd (177734112)
[35401227.266081] dtrep: unsupported fallocate mode 3: vault_txn_count.ibd (177734114)
[35401227.266100] dtrep: unsupported fallocate mode 3: vault_txn_count.ibd (177734114)
[35468366.938875] EXT4-fs (vdb): error count since last fsck: 5704
[35468366.938886] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[35468366.938888] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[35554874.418357] EXT4-fs (vdb): error count since last fsck: 5704
[35554874.418367] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[35554874.418369] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[35641381.897867] EXT4-fs (vdb): error count since last fsck: 5704
[35641381.897884] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[35641381.897888] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[35656095.160633] dtrep: unsupported fallocate mode 3: t1.ibd (177733942)
[35656095.160656] dtrep: unsupported fallocate mode 3: t1.ibd (177733942)
[35656207.768781] dtrep: unsupported fallocate mode 3: #sql-ib1681-2574536729.ibd (177733944)
[35656207.768807] dtrep: unsupported fallocate mode 3: #sql-ib1681-2574536729.ibd (177733944)
[35656974.478190] dtrep: unsupported fallocate mode 3: t2.ibd (177733942)
[35656974.478214] dtrep: unsupported fallocate mode 3: t2.ibd (177733942)
[35660077.057638] dtrep: unsupported fallocate mode 3: t3.ibd (177733946)
[35660077.057683] dtrep: unsupported fallocate mode 3: t3.ibd (177733946)
[35660163.252600] dtrep: unsupported fallocate mode 3: #sql-ib1684-2574536731.ibd (177733948)
[35660163.252640] dtrep: unsupported fallocate mode 3: #sql-ib1684-2574536731.ibd (177733948)
[35660301.838772] dtrep: unsupported fallocate mode 3: #sql-2f07_8a9f.ibd (177733946)
[35660301.838796] dtrep: unsupported fallocate mode 3: #sql-2f07_8a9f.ibd (177733946)
[35727889.377311] EXT4-fs (vdb): error count since last fsck: 5704
[35727889.377329] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[35727889.377332] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[35814396.856796] EXT4-fs (vdb): error count since last fsck: 5704
[35814396.856807] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[35814396.856809] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[35824120.782028] dtrep: unsupported fallocate mode 3: audit_webservice_aua_bkp06Dec.ibd (177733950)
[35824120.782053] dtrep: unsupported fallocate mode 3: audit_webservice_aua_bkp06Dec.ibd (177733950)
[35835108.021042] dtrep: unsupported fallocate mode 3: audit_webservice_aua.ibd (177733920)
[35835108.021074] dtrep: unsupported fallocate mode 3: audit_webservice_aua.ibd (177733920)
[35900904.336350] EXT4-fs (vdb): error count since last fsck: 5704
[35900904.336377] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[35900904.336382] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[35932946.982484] Request for unknown module key 'Trend Micro Deep Security 12: 5739d58b6ddc0e6bd8aad25be7a3c8b6af7bdc23' err -11
[35932947.063180] tmhook: tmhook 1.2.1362 loaded
[35932947.096914] Request for unknown module key 'Trend Micro Deep Security 12: 5739d58b6ddc0e6bd8aad25be7a3c8b6af7bdc23' err -11
[35932948.240206] Request for unknown module key 'Trend Micro Deep Security 12: 5739d58b6ddc0e6bd8aad25be7a3c8b6af7bdc23' err -11
[35932948.242479] Redirecting File System Framework Version 0.10 <www.redirfs.org> with TrendMicro Patch 1.4353.9e3c7b8
[35932948.261795] Request for unknown module key 'Trend Micro Deep Security 12: 5739d58b6ddc0e6bd8aad25be7a3c8b6af7bdc23' err -11
[35932948.272706] register_chrdev(gsch_dev) done: 244
[35932948.272784] gsch: set bootup time to 1666039806502000000
[35932948.272785] gsch: loading vfs-filter 1.4353.9e3c7b8: OK
[35932948.285418] gsch_dev_open(gsch_dev) doing
[35932948.285424] gsch_dev_open() done: pid:6076(ds_am)
[35932948.291223] gsch_install_hook(name=sys_open,nr=002,pre=1,post=1) ref=2 done
[35932948.291234] gsch_install_hook(name=sys_openat,nr=257,pre=1,post=1) ref=2 done
[35932948.291236] gsch_install_hook(name=sys_creat,nr=085,pre=1,post=1) ref=2 done
[35932948.291238] gsch_install_hook(name=sys_close,nr=003,pre=1,post=1) ref=2 done
[35932948.291240] gsch_install_hook(name=sys_dup2,nr=033,pre=1,post=1) ref=2 done
[35932948.291242] gsch_install_hook(name=sys_dup3,nr=292,pre=1,post=1) ref=2 done
[35932948.291243] gsch_install_hook(name=sys_exit,nr=060,pre=1,post=0) ref=1 done
[35932948.291245] gsch_install_hook(name=sys_exit_group,nr=231,pre=1,post=0) ref=1 done
[35932948.291247] gsch_install_hook(name=sys_write,nr=001,pre=0,post=1) ref=1 done
[35932948.291249] gsch_install_hook(name=sys_writev,nr=020,pre=0,post=1) ref=1 done
[35932948.291251] gsch_install_hook(name=sys_pwrite64,nr=018,pre=0,post=1) ref=1 done
[35932948.291253] gsch_install_hook(name=sys_unlink,nr=087,pre=1,post=1) ref=2 done
[35932948.291254] gsch_install_hook(name=sys_unlinkat,nr=263,pre=1,post=1) ref=2 done
[35932948.291256] gsch_install_hook(name=sys_execve,nr=059,pre=1,post=0) ref=1 done
[35932948.291258] gsch_install_hook(name=sys_rename,nr=082,pre=1,post=1) ref=2 done
[35932948.291260] gsch_install_hook(name=sys_renameat,nr=264,pre=1,post=1) ref=2 done
[35932948.291262] gsch_install_hook(name=sys_renameat2,nr=316,pre=1,post=1) ref=2 done
[35932948.291264] gsch_install_hook(name=sys_chmod,nr=090,pre=1,post=1) ref=2 done
[35932948.291266] gsch_install_hook(name=sys_fchmod,nr=091,pre=1,post=1) ref=2 done
[35932948.291295] gsch_install_hook(name=sys_fchmodat,nr=268,pre=1,post=1) ref=2 done
[35932948.291297] gsch_install_hook(name=sys_chown,nr=092,pre=1,post=1) ref=2 done
[35932948.291299] gsch_install_hook(name=sys_fchown,nr=093,pre=1,post=1) ref=2 done
[35932948.291301] gsch_install_hook(name=sys_lchown,nr=094,pre=1,post=1) ref=2 done
[35932948.291303] gsch_install_hook(name=sys_fchownat,nr=260,pre=1,post=1) ref=2 done
[35932948.291305] gsch_install_hook(name=sys_mount,nr=165,pre=1,post=1) ref=2 done
[35932948.291307] gsch_install_hook(name=sys_umount,nr=166,pre=1,post=1) ref=2 done
[35932948.291308] gsch_install_hooks() done: 0
[35932948.480131] gsch_redirfs: loaded
[35987411.815818] EXT4-fs (vdb): error count since last fsck: 5704
[35987411.815828] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[35987411.815830] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[36073919.295353] EXT4-fs (vdb): error count since last fsck: 5704
[36073919.295364] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[36073919.295366] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[36160426.774783] EXT4-fs (vdb): error count since last fsck: 5704
[36160426.774802] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[36160426.774805] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[36246934.254293] EXT4-fs (vdb): error count since last fsck: 5704
[36246934.254308] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[36246934.254311] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[36333441.734752] EXT4-fs (vdb): error count since last fsck: 5704
[36333441.734761] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[36333441.734764] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[36351235.859394] dtrep: unsupported fallocate mode 3: audit_webservice_aua_Dec12.ibd (177733952)
[36351235.859418] dtrep: unsupported fallocate mode 3: audit_webservice_aua_Dec12.ibd (177733952)
[36419949.213231] EXT4-fs (vdb): error count since last fsck: 5704
[36419949.213241] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[36419949.213243] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[36506456.692760] EXT4-fs (vdb): error count since last fsck: 5704
[36506456.692783] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[36506456.692786] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[36592964.172224] EXT4-fs (vdb): error count since last fsck: 5704
[36592964.172240] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[36592964.172243] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[36679471.651739] EXT4-fs (vdb): error count since last fsck: 5704
[36679471.651771] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[36679471.651774] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[36765979.131211] EXT4-fs (vdb): error count since last fsck: 5704
[36765979.131226] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[36765979.131228] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[36852486.610705] EXT4-fs (vdb): error count since last fsck: 5704
[36852486.610716] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[36852486.610718] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
[36938994.090183] EXT4-fs (vdb): error count since last fsck: 5704
[36938994.090193] EXT4-fs (vdb): initial error at time 1585715471: ext4_mb_generate_buddy:757
[36938994.090195] EXT4-fs (vdb): last error at time 1701247536: ext4_lookup:1441: inode 2359299
kiindly help me to recover my data.
Warm Regards.