innobackupex err
ERR
2023-09-14 09:00:10 时间
[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;
相关文章
- Xmit_Err Rcv_Err 异常计数器
- PhpExcel导出excel报错:net::ERR_INVALID_RESPONSE
- 成功解决ERROR: Could not find a version that satisfies the requirement xgboost (from versions: none) ERR
- npm ERR! Could not resolve dependency:npm ERR! peer vue@“^2.5.17“ from element-ui@2.15.12
- 已解决raise JSONDecodeError(“Expecting value”, s, err.value) from None
- node-redis:ErrorReply: ERR wrong number of arguments for ‘auth‘ command
- [Err] 1093 - You can't specify target table 'user' for update in FROM clause
- 【问题解决】(error) ERR Errors trying to SHUTDOWN. Check logs
- 浏览器经常打不开网站,出现ERR_FAILED