src386
July 13, 2015, 10:10am
1
Hi everyone,
I’m running percona-xtrabackup in a test environment and I’m getting that weird error :
Here is the full output :
root@percona:~# innobackupex --host=10.10.25.163 --user=percona --password=mypassword /data/percona/db/
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/p
150713 17:26:04 innobackupex: Executing a version check against the server…
150713 17:26:04 innobackupex: Connecting to MySQL server with DSN ‘dbi:mysql:;mysql_read_default_group=xtrabackup;host=10.10.25.163’ as ‘percona’ (using password: YES).
150713 17:26:04 innobackupex: Connected to MySQL server
150713 17:26:04 innobackupex: Done.
150713 17:26:04 innobackupex: Connecting to MySQL server with DSN ‘dbi:mysql:;mysql_read_default_group=xtrabackup;host=10.10.25.163’ as ‘percona’ (using password: YES).
150713 17:26:04 innobackupex: Connected to MySQL server
150713 17:26:04 innobackupex: Starting the backup operation
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex
prints “completed OK!”.
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 3692
main::init() called at /usr/bin/innobackupex line 1574
innobackupex: Error: option ‘datadir’ has different values:
‘/var/lib/mysql’ in defaults file
‘/var/lib/mysql/’ in SHOW VARIABLES
I created a local file percona.cnf with the following line :
datadir = /var/lib/mysql/
Then ran innobackupex :
innobackupex --host=10.10.25.163 --user=percona --password=mypassword --defaults-file=percona.cnf /data/percona/db/
But know I get this :
What can I do ?
Thanks
Xavier C.
src386
July 15, 2015, 2:03am
2
Ok, it’s not possible to backup a remote host. The --host parameter is set when you want to store your backup to a remote server :
[url]Percona XtraBackup
Older version of Percona Xtrabackup (2.0) has the --remote-host option, but latest versions of PXB (2.1 and 2.2) don’t support it anymore.