MySQL backup Error: error occurred while opening file "/tmp/MySQL_Temp_BKF_token/user/database/db.opt" for node "User/database/db.opt". Reason: No such file or directory

Last Modified

Fri Apr 29 10:16 GMT 2022

Description

  • MySQL backup gets the error:
    • Error occurred while opening file "/tmp/MySQL_Temp_BKF_token/user/database/db.opt" for node "User/database/db.opt". Reason: No such file or directory

Environment

  • Cove Data Protection

  • N-able RMM

    • Backup & Recovery
  • N-able N-central
    • N-able Backup

Solution

  • To resolve issue, change temporary directory in Backup Manager
    1. Click on Prefences tab
    2. Select Advanced tab
    3. Choose directory on partition with sufficient space to store all MySQL DBs during backup process
    4. Click Save
  • ?Can also be done via ClientTool.exe using below command
    • ClientTool control.setting.modify -name TempDir -value /path/to/temp/dir/
    • Select directory on partition with sufficient space to store all MySQL DBs during backup process