Article ID: 62643
Article Type: Troubleshooting
Last Modified:
A backup operation for MySQL fails with Error Code: [87:86]
A backup operation for MySQL databases fails with the following error on the client computer.
ERROR CODE [87:86]: Failure:[~Current Version of MySQL has product bug [http://bugs.mysql.com/bug.php?id=72598]. Please upgrade MySQL to continue with backups.~]
The backup operation fails because of a MySQL bug or a MariaDB bug. If it is a MySQL bug [http://bugs.mysql.com/bug.php?id=72598], then execution of the FLUSH LOGS command fails when both --syslog for mysqld_safe and --log-error for mysqld are enabled in the MySQL config file. If it is a MariaDB bug [https://jira.mariadb.org/browse/MDEV-10241], then execution of the FLUSH LOGS command fails when the absolute path is used for the log-error parameter in the MariaDB config file.
If it is a MySQL bug, then you need to remove one of the parameters from the corresponding MySQL config file, either --syslog from the mysqld_safe section or log-error from the mysqld section. If it is a MariaDB bug, then you need to update the value of the log-error parameter to the relative path in the MariaDB config file, and then restart the MariaDB services.