# How to do a full backup of all databases

**URL:** <https://forums.percona.com/t/how-to-do-a-full-backup-of-all-databases/3256>\
**Category:** Percona XtraBackup\
**Created:** [February 6, 2014, 11:39am UTC](https://forums.percona.com/t/how-to-do-a-full-backup-of-all-databases/3256 "2014-02-06T11:39:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bexicusmaximus](https://avatars.discourse-cdn.com/v4/letter/b/a183cd/32.png) [@bexicusmaximus](https://forums.percona.com/u/bexicusmaximus)\
**Post date:** [February 6, 2014, 11:39am UTC](https://forums.percona.com/t/how-to-do-a-full-backup-of-all-databases/3256/1 "2014-02-06T11:39:07Z")

</div>

I apologize in advance if I’m being stupid, but how do I go about getting xtrabackup to do a full back up of all dbs from a remote server? This is the command line that I have been using. But when I try to do a full backup of all dbs, it finishes within seconds and says “innobackupex: completed OK!” everytime. It’s impossible to back up that much data in less than a minute. So this leads me to believe I’m doing something wrong.

innobackupex --defaults-file=/etc/my.cnf --databases=/path/to/databases.txt --host=ipaddr --user=user–password=pass /path/to/bkupdir/ \> /path/to/log.log 2\>&1

Any help/pointers/guidance would be appreciated. Thanks.

---

<div class="post-metadata">

**Author:** ![mirfan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mirfan/32/16890_2.png) [@mirfan](https://forums.percona.com/u/mirfan)\
**Post date:** [February 9, 2014, 3:43pm UTC](https://forums.percona.com/t/how-to-do-a-full-backup-of-all-databases/3256/2 "2014-02-09T15:43:48Z")

</div>

How big is the dataset ? Did you tried to restore the backup to check if it restore successfully to see this will verify if backup is usable or not. Moreover, all your data is InnoDB or using mix of MyISAM & InnoDB ? BTW, there is no need to mention --databases option if you need to backup all databases. I would recommend to read the documentation here [url][Percona XtraBackup](http://www.percona.com/doc/percona-xtrabackup/2.1/howtos/recipes_ibkx_local.html%5B/url%5D) for further details on it.