Not the answer you need?
Register and ask your own question!

Errors on restoration

strategesimstrategesim EntrantInactive User Role Beginner
Hello,

I encounter some strange errors when I try to restore a mysql backup made by my hosting provider.
I don’t manage to solve the error, even with a new mysql config file.
Perhaps you can help ? I am on MacOSX, mysql Ver 14.14 Distrib 5.7.11
sh-3.2# ./Downloads/xtrabackup-1.6.2/bin/innobackupex ./../Documents/chs-web-02 
   
  InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
  and Percona Inc 2009-2011.  All Rights Reserved.
   
  This software is published under
  the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
   
  160329 10:23:05  innobackupex: Starting mysql with options:  --unbuffered --
  160329 10:23:05  innobackupex: Connected to database with mysql child process (pid=23088)
  160329 10:23:12  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.7.11, for osx10.9 (x86_64) using  EditLine wrapper
  innobackupex: Using mysql server version Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
   
  Use of uninitialized value $option_ibbackup_binary in concatenation (.) or string at ./Downloads/xtrabackup-1.6.2/bin/innobackupex line 1971.
  Can't exec "--print-param": No such file or directory at ./Downloads/xtrabackup-1.6.2/bin/innobackupex line 1972.
  innobackupex: fatal error: no 'mysqld' group in MySQL options
  innobackupex: fatal error: OR no 'datadir' option in group 'mysqld' in MySQL options
   
Thanks

Comments

  • mirfanmirfan Database Administrator Inactive User Role Beginner
    please provide exact commands used for backup, --apply-log and to restore. Along with that show contents for backup-my.cnf from backup directory and my.cnf file of MySQL instance where you are restoring.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.