Troubleshooting
Problem
Why does MySQL database backup fail ?
Resolving The Problem
Why does MySQL database backup fail ?
Symptom: The cronjob script that backs up the MySQL database fails to run. This script is /etc/cron.daily/backup-cluster-db.
Explanation: The apache user does not have the proper permissions to lock the database tables.
Solution: As a workaround, log on to the MySQL database and run the following commands:
# grant lock tables on cluster.* to apache@localhost;
# grant lock tables on cluster.* to apache@
[{"Product":{"code":"SSZUCA","label":"IBM Spectrum Cluster Foundation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSZUCA","label":"IBM Spectrum Cluster Foundation"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":null,"Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
11 September 2018
UID
isg3T1013886