Problem with restore .sql files

Products

• Network Observability

Issue/Introduction

Unable to restore .sql file due to error:

ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode to 1 if ASCII '\0' is expected. Query: '-'.

Environment

NFA - 23.3.x

OS - Windows

Cause

User was using powershell to backup mysql database, encoding in powershell is different than what is expected in NFA. 

Resolution

Default encoding used in NFA is utf8mb4 hence it is always recommended to use 'Command Prompt' with Admin privilege to take MySQL(harvester and reporter) DB backup.

Do not use powershell to take backup.