Error Code: [87:83] Log restore operation failed

A MySQL log file restore job fails with Error Code [87:83]

Symptoms

A log file restore job fails with the following error message:

Error Code: [87:86] Description: Failure:[~Error [/usr/bin/mysqlbinlog: unknown option '--no-beep' ] in applying the logs~]

You can also find following error in the MySqlRestore.log file:

44063 ac1f 02/09 13:09:07 3007 MySqlChildProcess::CV_CreateProcess() - Command to run [/usr/bin/mysqlbinlog --start-position=120   -d auxdb_1 /clone/3007/21666/testlog.000336 --result-file=/clone/3007/21666/ArchiveEvents.sql] 44063 ac1f 02/09 13:09:07 3007 MySqlChildProcess::CV_CreateProcess() - Parent: child process pid= 44241 44063 ac1f 02/09 13:09:07 3007 MySqlChildProcess::Wait() - Child died after receiving signal 2 44063 ac1f 02/09 13:09:07 3007 MySqlLogRestore::ApplyTheLogFile() - Wait returned failure 44063 ac1f 02/09 13:09:07 3007 MySqlChildProcess::ReadErrBuf() - Previous errno = [9]. 44063 ac1f 02/09 13:09:07 3007 MySqlChildProcess::ReadErrBuf() - ReadFile: LastError=0 44063 ac1f 02/09 13:09:07 3007 MySqlChildProcess::ReadErrBuf() - Got Error /usr/bin/mysqlbinlog: unknown option '--no-beep' 44063 ac1f 02/09 13:09:08 3007 Sending FAILED complete message to JM, 3007

Causes

The no-beep option is present in the MySQL configuration file.

[client]
no-beep

Resolution

Use the following steps to resolve this issue:

1. Open the MySQL configuration file, and then comment out the no-beep option.

[client]
#no-beep

2. Run the log file restore operation again.