Issue Unable to make database dump. Error: Failed to exec mysqldump.exe: Exit code: 7

[NeFeS]

Server operating system version

Windows Server 2012 R2

Plesk version and microupdate number

Plesk Obsidian 18.0.44

Warning: Database "databasename"
Unable to make database dump. Error: Failed to exec mysqldump.exe: Exit code: 7: C:\Program Files (x86)\Plesk\MySQL\bin\mysqldump.exe: unknown variable 'sql_mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'


I'm getting this error, I couldn't find a solution.

While backing up on the Plesk panel, there is a problem with the database and I cannot extract it from the rar.

THANKS IN NOW.

 

[IgorG]

Try to apply solution For Windows server from this KB article: https://support.plesk.com/hc/en-us/...the-ONLY-FULL-GROUP-BY-SQL-mode-is-configured

 

[NeFeS]

Hello, I solved that problem. but

After taking the backup, I download the backup from Onedrive and I get an error while extracting the zip. What is the solution to this?

thanks .