1 Run Recovery command
[Email protected] tmp]$ Time/usr/bin/innobackupex --rsync --user= "user"--password= "#xxx $"/mysqldata/ Shared/backup
[
--rsync ] is able to record the master point for replication settings.
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, Innobase Oy
and Percona Inc 2009-2012. All rights Reserved.
This software is published under
the GNU general public LICENSE Version 2, June 1991.
131023 04:26:26 innobackupex:starting mysql with options:--password=xxxxxxxx--user= ' user '--unbuffered--
131023 04:26:26 innobackupex:connected to database with MySQL child process (pid=24497)
131023 04:26:32 innobackupex:connection to database server closed
important:please Check that the backup run completes successfully.
At the end of a successful backup run Innobackupex
prints "completed ok!".
innobackupex:using mysql Ver 14.14 distrib 5.5.25a, for Linux (x86_64) Using ReadLine 5.1
innobackupex:using MySQL server version Copyright (c), and/or, Oracle, its affiliates. All rights reserved.
Xtrabackup:Error:Please set parameter ' DataDir '
Innobackupex:fatal error:no ' mysqld ' Group in MySQL options
Innobackupex:fatal error:or No ' datadir ' option in Group ' mysqld ' in MySQL options
Real 0m6.379s
User 0m0.219s
SYS 0m0.124s
MySQL 26087 26086 0 04:32 PTS/3 00:00:00-bash
2 The check configuration file has no DataDir configuration parameters.
[Email protected] sharding_setup_1]$ cat/xxx/xxx/xxx/5.5.25a/my.cnf |grep datadir
Datadir=/mysqldata/data
It looks like the my.cnf inside has been configured.
3 Define your own backup make my.cnf, try to look.
[Email protected] backup]$ Time/usr/bin/innobackupex--rsync--user= "user"--password= "#xxx $"--defaults-file=/opt/ Xxx/xxx/5.5.25a/my.cnf/mysqldata/backup
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, Innobase Oy
and Percona Inc 2009-2012. All rights Reserved.
This software is published under
The GNU general public LICENSE Version 2, June 1991.
131023 06:33:41 innobackupex:starting mysql with options:--defaults-file= '/opt/xxx/xxx/5.5.25a/my.cnf '--password= xxxxxxxx--user= ' user '--unbuffered--
131023 06:33:41 innobackupex:connected to database with MySQL child process (pid=22321)
131023 06:33:47 innobackupex:connection to database server closed
Important:please Check that the backup run completes successfully.
At the end of a successful backup run Innobackupex
Prints "completed ok!".
innobackupex:using MySQL Ver 14.14 distrib 5.5.25a, for Linux (x86_64) Using ReadLine 5.1
innobackupex:using MySQL server version Copyright (c), and/or, Oracle, its affiliates. All rights reserved.
innobackupex:created Backup directory/mysqldata/shared/backup/2013-10-23_06-33-47
131023 06:33:47 innobackupex:starting mysql with options:--defaults-file= '/opt/xxx/xxx/5.5.25a/my.cnf '--password= xxxxxxxx--user= ' user '--unbuffered--
131023 06:33:47 innobackupex:connected to database with MySQL child process (pid=22358)
131023 06:33:49 innobackupex:connection to database server closed
131023 06:33:49 innobackupex:starting ibbackup with command:xtrabackup_55--defaults-file= "/opt/xxx/xxx/5.5.25a/ My.cnf "--backup--suspend-at-end--target-dir=/mysqldata/shared/backup/2013-10-23_06-33-47
Innobackupex:waiting for Ibbackup (pid=22419) to suspend
Innobackupex:suspend file '/mysqldata/shared/backup/2013-10-23_06-33-47/xtrabackup_suspended '
xtrabackup_55 version 2.0.0 for Percona Server 5.5.16 Linux (x86_64) (revision id:417)
Xtrabackup:uses posix_fadvise ().
XTRABACKUP:CD To/mysqldata/data
Xtrabackup:target instance is assumed as followings.
Xtrabackup:innodb_data_home_dir =/mysqldata/data
Xtrabackup:innodb_data_file_path = Ibdata01:1g:autoextend
Xtrabackup:innodb_log_group_home_dir =/mysqldata/iblogs
Xtrabackup:innodb_log_files_in_group = 2
Xtrabackup:innodb_log_file_size = 1073741824
131023 6:33:49 innodb:using Linux native AIO
Xtrabackup:using O_direct
131023 6:33:49 InnoDB:Warning:allocated tablespace, old maximum was 9
>> Log scanned up to (450994458760)
[Copying/mysqldata/data/ibdata01 TO/MYSQLDATA/SHARED/BACKUP/2013-10-23_06-33-47/IBDATA01]
>> Log scanned up to (450994626288)
>> Log scanned up to (450994768050)
[... done]
[Copying]/billing/enum_invoice_tax_status.ibd to/mysqldata/shared/backup/2013-10-23_06-33-47/./xxx/ Xxxxtb.ibd
[... done]
[Production environment Data Recovery]innobackupex:fatal error:or no & #39;d atadir& #39; option in Group & #39;mysqld& #39; In MySQL options