Not the answer you need?
Register and ask your own question!

xtrabackup not recover my table

wangyiran125wangyiran125 EntrantInactive User Role Beginner
i try xtrabackup --backup --datadir=/var/lib/mysql/ --target-dir=/root/backup/
xtrabackup --prepare --target-dir=/root/backup

and then drop table a;
rsync -avrP /root/backup/ /var/lib/mysql/
chown -R mysql:mysql /var/lib/mysql,

but when i relogin mysql,and check database test1 the table a not exist!
the table a is innodb engine,why not recover?


  • wangyiran125wangyiran125 Entrant Inactive User Role Beginner
    i see mysql test1 database directory contains a.frm a.ibd ,but after rsync,this a table not restore
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.