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.