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

innobackupex: Error: Failed to connect to MySQL server:

JBeasonJBeason EntrantInactive User Role Beginner
Trying to run innobackupex and receiving the following error message:
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.
Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/ubuntu

141111 15:14:01 innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'dba' (using password: YES).
innobackupex: Error: Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup','dba',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/bin/innobackupex line 2945.




Here is some system information:
mysql --version
mysql Ver 14.14 Distrib 5.6.19, for debian-linux-gnu (x86_64) using EditLine wrapper


uname -a
Linux ip-172-**-**-*** 3.13.0-24-generic #47-Ubuntu SMP Fri May 2 23:30:00 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux


cat /etc/*release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=14.04
DISTRIB_CODENAME=trusty
DISTRIB_DESCRIPTION="Ubuntu 14.04.1 LTS"
NAME="Ubuntu"
VERSION="14.04.1 LTS, Trusty Tahr"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 14.04.1 LTS"
VERSION_ID="14.04"
HOME_URL="http://www.ubuntu.com/"
SUPPORT_URL="http://help.ubuntu.com/"
BUG_REPORT_URL="http://bugs.launchpad.net/ubuntu/"



aptitude show libdbd-mysql-perl
Package: libdbd-mysql-perl
State: installed
Automatically installed: yes
Version: 4.025-1
Priority: optional
Section: perl
Maintainer: Ubuntu Developers <[email protected]>
Architecture: amd64
Uncompressed Size: 314 k
Depends: perl (>= 5.18.1-4build1), perl-dbdabi-94, perlapi-5.18.1, libc6 (>= 2.4), libmysqlclient18 (>= 5.5.13-1), libdbi-perl
Description: Perl5 database interface to the MySQL database
DBD::mysql is the Perl5 Database Interface driver for the MySQL database. In other words: DBD::mysql is an interface between the Perl programming language and the MySQL programming API that comes with the MySQL relational database
management system. Most functions provided by this programming API are supported. Some rarely used functions are missing, mainly because noone ever requested them. However supported features include: compression of data between server
and client; timeouts; SSL; prepared statement support; server administration such as creating and dropping databases and restarting the server; auto-reconnection; utf8; bind type guessing; bind comment placeholders; automated insert
ids; transactions; multiple result sets and multithreading.
Homepage: https://metacpan.org/release/DBD-mysql

Comments

  • mirfanmirfan Database Administrator Inactive User Role Beginner
    It seems that your credentials are not correct for innobackupex command. Would you able to connect manually ?
  • JBeasonJBeason Entrant Inactive User Role Beginner
    mirfan, I verified that I do have the correct credentials. Thank you for your input.

    I stumbled onto the solution. I needed to add the -host [ip address] variable to get it to connect.
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.