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

Partial backup - complete ibdata1

ghost974ghost974 EntrantCurrent User Role Beginner

I trying to backup some InnoDB databases, but I noticed that the backed-up ibdata1 is as large as the whole databases.

What am I doing wrong ?
MySQL 5.5

I used :

innobackupex --user=root --databases="db1 db2 db3" /my/home/
innobackupex --apply-log /my/home/xtrabackup/

and then innobackupex --copy-back /my/home/xtrabackup/

Thanks !


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.