# xtrabackup dumps only one DB

**URL:** <https://forums.percona.com/t/xtrabackup-dumps-only-one-db/4824>\
**Category:** Percona XtraBackup\
**Created:** [April 5, 2016, 7:22am UTC](https://forums.percona.com/t/xtrabackup-dumps-only-one-db/4824 "2016-04-05T07:22:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![djmentos](https://avatars.discourse-cdn.com/v4/letter/d/d6d6ee/32.png) [@djmentos](https://forums.percona.com/u/djmentos)\
**Post date:** [April 5, 2016, 7:22am UTC](https://forums.percona.com/t/xtrabackup-dumps-only-one-db/4824/1 "2016-04-05T07:22:50Z")

</div>

Hello,

I’m trying to backup whole MySQL instance, running:  
sudo xtrabackup --host=[db.server.com](http://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

```auto
backup-my.cnf test_production mysql xtrabackup_binlog_info xtrabackup_info
ibdata1 test_staging performance_schema xtrabackup_checkpoints xtrabackup_logfile

```

```auto

# 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).

---

<div class="post-metadata">

**Author:** ![George\_Lorch](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/george_lorch/32/1108_2.png) [@George\_Lorch](https://forums.percona.com/u/George_Lorch)\
**Post date:** [April 5, 2016, 9:01am UTC](https://forums.percona.com/t/xtrabackup-dumps-only-one-db/4824/2 "2016-04-05T09:01:14Z")

</div>

Percona XtraBackup must be executed on the same host as mysqld. It sounds like you might be trying to run from another host.

See this blog post for a good review of how to use XtraBackup with multiple hosts : [url][stevecoug (Steve Meyers) · GitHub](http://www.stevemeyers.net/2013/06/using-xtrabackup-to-backup-remote.html%5B/url%5D)

–  
George O. Lorch III  
Software Engineer, Percona