Resolved Unable to backup databases (Exit code: 7)

[Kranf]

Server operating system version

debian

Plesk version and microupdate number

Plesk Obsidian Version 18.0.44 Update #3

We are getting errors with the backup manager from Plesk which is unable to backup the databases from our server. For example:
Warning: Database "xenforo_a"
Unable to make database dump. Error: Failed to exec mysqldump: Exit code: 7: mysqldump: unknown variable 'ft_min_word_len=3'

These errors happens since we added the parameter:
ft_min_word_len=3
inside our "my.cnf" file from mysql. We need this parameter to allow users to do a search with only 3 caracters (instead of the default 4) in our Xenforo forum.

How can we fix this?
Any help is deeply appreciated because our server is without any backup since 2 months and the official "Plesk Support" is ignoring us.
Thanks in advance for your help.
Kind regards,
Frank

 

[Bitpalast]

This can occur when the parameter is set under the [mysqldump] section. Make sure that is is only present in the [mysqld] section, but not in the [mysqldump] section.