Shulou(Shulou.com)05/31 Report--

This article focuses on "how to solve the problem of innobackupex: Error: no error in mysql". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Let the editor take you to learn "how to solve the problem of innobackupex: Error: no error reporting in mysql"!

Environment introduction:

MySQL5.6.19

RedHat 6.3 _ x64

Error while doing MySQL innobackup recovery on different machine

[root@newbidb bin] #. / innobackupex-- user=root-- password=root1-- defaults-file=/etc/my.cnf-- copy-back / u02/backup/

Appears in the error message:

IMPORTANT: Please check that the copy-back run completes successfully.

At the end of a successful copy-back run innobackupex

Prints "completed OK!".

Sh: autodetect: command not found

Innobackupex: Error: no 'mysqld' group in MySQL options at. / innobackupex line 4397

Solution:

1. Determine whether the xtrabackup package has been installed in the system, and the best version corresponds to the version of MySQL.

[root@newbidb bin] # rpm-ivh percona-xtrabackup-2.2.3-4982.el6.x86_64.rpm

This can be downloaded from the official website, http://www.percona.com/downloads/XtraBackup/

If the following error occurs:

Check to see if the-- defaults-file=/etc/my.cnf parameter is correct, and check whether the my.cnf is correct.

Innobackupex: fatal error: no 'mysqld' group in MySQL options

Innobackupex: fatal error: OR no 'datadir' option in group' mysqld' in MySQL options

At this point, I believe you have a deeper understanding of "how to solve the problem of innobackupex: Error: no error reporting in mysql". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.