Can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied

Products

• CA API Gateway

Issue/Introduction

mysql dump command fails with can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied

Environment

Release:
Component: APIGTW

Resolution

1. Run the following command to backup mysql DB if you come across this error "can't backup the mysql table with mysqldump. SELECT,LOCK TABL command denied"

 mysqldump --skip-lock-tables -u root -p --all-databases | gzip > /home/ssgconfig/<filename>.sql.gz

2. This will write the file to /home/ssgconfig but the location can be changed according to the requirement.