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

xtrabackup dumps only one DB

djmentosdjmentos EntrantInactive User Role Participant
Hello,

I'm trying to backup whole MySQL instance, running:
sudo xtrabackup --host=db.server.com --user=root --password=secret.8 --backup --target-dir="/tmp/backup_dir"

It copies mysql, performance_schema, test_staging DBs properly, and in the last dir: test_production it is only db.opt file without any table files. Any hint how to fix it?

ls /tmp/backup_dir
tmp/test/2016-04-05_12-10-59# ls
backup-my.cnf  test_production  mysql               xtrabackup_binlog_info  xtrabackup_info
ibdata1        test_staging     performance_schema  xtrabackup_checkpoints  xtrabackup_logfile
# ls -l mysql | wc -l
80
# ls -l performance_schema/ | wc -l
54
# ls -l test_staging | wc -l
626
# ls -l test_production/ | wc -l
2
Both test_* should contain same tables (but with another data).

Comments

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.