I’m sure this Q has been asked somewhere before (or its obvious to everyone but me) but I’m unable to find anything searching the forum or web or Percona FAQ’s.
Is XtraBackup compatible with MySQL 5.6?
If its not then I understand why things arent working and I’ll just have to be patient and one day it may be available for that too. I know the online docs only mention up to 5.5 but nowhere does it tell me that it wont work with a newer version which is why I tried. If this is the case then please ignore the below.
I installed XtraBackup (latest) today for the first time on SuSE Linux (SLES11SP2). The RHEL repos wouldnt add when I tried so I went with the RHEL 2.05-499 x64 rpm install suggested here
I then ran what I thought was the simplest backup possible using the ffg command:
innobackupex-1.5.1 --user=root --password=‘xxxx’ /tmp
I get these results
InnoDB Backup Utility v1.5.1-xtrabackup
130311 15:59:55 innobackupex-1.5.1: Starting mysql with options: --password=xxxxxxxx --user=‘root’ --unbuffered –
130311 15:59:55 innobackupex-1.5.1: Connected to database with mysql child process (pid=28184)
130311 16:00:01 innobackupex-1.5.1: Connection to database server closed
IMPORTANT: Please check that the backup run completes successfully.
At the end of a successful backup run innobackupex-1.5.1
prints “completed OK!”.
innobackupex-1.5.1: Using mysql Ver 14.14 Distrib 5.6.10, for Linux (x86_64) using EditLine wrapper
innobackupex-1.5.1: Using mysql server version Copyright © 2000, 2013, Oracle and/or its affiliates. All rights reserved.
sh: --: invalid option
innobackupex-1.5.1: fatal error: no ‘mysqld’ group in MySQL options
Can anyone explain what I’m missing. Thanks