Need help backing up Performance Center MySQL Database

Products

• DX NetOps
• CA Performance Management - Usage and Administration

Issue/Introduction

Getting the following error running mysqldump

mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect

Environment

Release : 22.2

Resolution

Use -h 127.0.01 in the mysql dump command.

/opt/ca/pc/MySql/bin/mysqldump --routines -uroot -p -h 127.0.0.1 netqosportal > /opt/ca/backups/netqosportal.sql