innobackupex err

 

[root@12db etc]# innobackupex --user=root /dbback/

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona Inc 2009-2012.  All Rights Reserved.

This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

160620 16:47:59  innobackupex: Starting mysql with options:  --user='root' --unbuffered --
160620 16:47:59  innobackupex: Connected to database with mysql child process (pid=25640)
160620 16:48:05  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.20, for Linux (x86_64) using readline 5.1
innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

xtrabackup_55: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
innobackupex: fatal error: no 'mysqld' group in MySQL options
innobackupex: fatal error: OR no 'datadir' option in group 'mysqld' in MySQL options
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[root@12db etc]# yum install -y libaio*
#问题解决！！！

 

 Last_Errno: 1007
                   Last_Error: Error 'Can't create database 'ceshi'; database exists' on query. Default database: 'ceshi'. Query: 'create database ceshi'
vi /etc/my.cnf
[mysqld]
#skip-grant-tables
slave_skip_errors = 1007
同时使用：
SQL_SLAVE_SKIP_COUNTER
mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1;