xtrabackup: Error: Please set parameter 'datadir',innoback_MySQL
bitsCN.com
xtrabackup: Error: Please set parameter 'datadir',innobackupex: fatal error: no 'mysqld' group in解决
-- 报错:
[root@5.5.25a]# innobackupex --rsync --user=backupusertmp --password=backupusertmp /mysqldata/shared/tmpbackupInnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona Inc 2009-2012. All Rights Reserved.This software is published underthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.130716 10:38:27 innobackupex: Starting mysql with options: --password=xxxxxxxx --user='backupusertmp' --unbuffered --130716 10:38:27 innobackupex: Connected to database with mysql child process (pid=6083)130716 10:38:33 innobackupex: Connection to database server closedIMPORTANT: 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.1innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.xtrabackup: Error: Please set parameter 'datadir'innobackupex: fatal error: no 'mysqld' group in MySQL optionsinnobackupex: fatal error: OR no 'datadir' option in group 'mysqld' in MySQL options
解决办法: 添加
--defaults-file=/opt/mysql/product/5.5.25a/my.cnf
[root@5.5.25a]# innobackupex --rsync --user=backupusertmp --password=backupusertmp --defaults-file=/opt/mysql/product/5.5.25a/my.cnf /mysqldata/shared/tmpbackupInnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona Inc 2009-2012. All Rights Reserved.This software is published underthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.130716 10:44:29 innobackupex: Starting mysql with options: --defaults-file='/opt/mysql/product/5.5.25a/my.cnf' --password=xxxxxxxx --user='backupusertmp' --unbuffered --130716 10:44:29 innobackupex: Connected to database with mysql child process (pid=6595)130716 10:44:35 innobackupex: Connection to database server closedIMPORTANT: 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.1innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.innobackupex: Error: Failed to create backup directory /mysqldata/shared/tmpbackup/2013-07-16_10-44-35: No such file or directory at /usr/bin/innobackupex line 371.
看到文件目录不存在,所以mkdir目录
[root@5.5.25a]# mkdir /mysqldata/shared/tmpbackup/[root@5.5.25a]# innobackupex --rsync --user=backupusertmp --password=backupusertmp --defaults-file=/opt/mysql/product/5.5.25a/my.cnf /mysqldata/shared/tmpbackupInnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oyand Percona Inc 2009-2012. All Rights Reserved.This software is published underthe GNU GENERAL PUBLIC LICENSE Version 2, June 1991.130716 10:46:24 innobackupex: Starting mysql with options: --defaults-file='/opt/mysql/product/5.5.25a/my.cnf' --password=xxxxxxxx --user='backupusertmp' --unbuffered --130716 10:46:24 innobackupex: Connected to database with mysql child process (pid=6780)130716 10:46:30 innobackupex: Connection to database server closedIMPORTANT: 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.1innobackupex: Using mysql server version Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
开始复制进行
.................
bitsCN.com
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
Solution to PHP Fatal error: Call to undefined method PDO::prepare() in
Jun 22, 2023 pm 06:40 PM
PHP is a popular web development language that has been used for a long time. The PDO (PHP Data Object) class integrated in PHP is a common way for us to interact with the database during the development of web applications. However, a problem that some PHP developers often encounter is that when using the PDO class to interact with the database, they receive an error like this: PHPFatalerror:CalltoundefinedmethodPDO::prep
Solve the problem of 'error: incomplete type is not allowed' in C++ code
Aug 26, 2023 pm 08:54 PM
Solve the "error:incompletetypeisnotallowed" problem in C++ code. During the C++ programming process, you sometimes encounter some compilation errors. One of the common errors is "error:incompletetypeisnotallowed". This error is usually caused by operating on an incomplete type. This article will explain the cause of this error and provide several solutions. firstly, I
What should I do if 'Uncaught (in promise) Error: Request failed with status code 500' occurs when using axios in a Vue application?
Jun 24, 2023 pm 05:33 PM
It is very common to use axios in Vue applications. axios is a Promise-based HTTP client that can be used in browsers and Node.js. During the development process, the error message "Uncaught(inpromise)Error: Requestfailedwithstatuscode500" sometimes appears. For developers, this error message may be difficult to understand and solve. This article will explore this
0271: What should I do if the computer cannot be turned on due to real time clock error?
Mar 13, 2023 am 11:30 AM
Solution to "0271: real time clock error" that cannot boot: 1. Press F1, and in the interface that appears, move the option bar to the third item "Date/Time"; 2. Manually change the system time to the current one time; 3. Press F10 and select yes in the pop-up dialog box; 4. Re-open the notebook to boot normally.
Solve the 'error: expected initializer before 'datatype'' problem in C++ code
Aug 25, 2023 pm 01:24 PM
Solve the "error:expectedinitializerbefore'datatype'" problem in C++ code. In C++ programming, sometimes we encounter some compilation errors when writing code. One of the common errors is "error:expectedinitializerbefore'datatype'". This error usually occurs in a variable declaration or function definition and may cause the program to fail to compile correctly or
How to solve PHP Warning: fopen(): failed to open stream: No such file or directory
Aug 19, 2023 am 10:44 AM
How to solve PHPWarning:fopen():failedtoopenstream:Nosuchfileordirectory In the process of using PHP development, we often encounter some file operation problems, one of which is "PHPWarning:fopen():failedtoopenstream:Nosuchfileordirectory"
Solution to PHP Fatal error: Call to undefined function mysqli_connect()
Jun 23, 2023 am 09:40 AM
When writing web applications using PHP, a MySQL database is often used to store data. PHP provides a way to interact with the MySQL database called MySQLi. However, sometimes when using MySQLi, you will encounter an error message, as shown below: PHPFatalerror:Calltoundefinedfunctionmysqli_connect() This error message means that PHP cannot find my
Solution to PHP Fatal error: Call to a member function fetch()
Jun 23, 2023 am 09:36 AM
When using PHP for web application development, you will often need to use a database. When using a database, error messages are very common. Among them, PHPFatalerror: Calltoamemberfunctionfetch() is a relatively common error that occurs when using PDO to query the database. So, what causes this error and how to solve it? This article will explain it in detail for you. 1. Cause of error
