ERROR: ASCII '\0' appeared in the statement, but this is not allowed unless option --binary-mode is enabled

[Vignesh R]

Hi guys,  Hope you are doing fine there. please explain me why i get this error while importing database . I am trying to retive my 400mb database and iam facing issue both on active host and local host xampp. Below is error. In active host i need to use SSH to load the database but while i login into my account via ssh and start the command 

mysql -u database_username -p database_name < file.sql

to activate db import via putty it is throwing this error. Please shed me more light on this. I Read this blog also https://r00t4bl3.com/post/how-to-fix-error-ascii-while-restoring-database-from-mysql-dump which addresses this issue but still cannot how to work around this issue.

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.

Edited November 24, 2022 by Vignesh R
moderator name mentioned previously (see edit history)

[juanrojas]

 

hello it should be something like this

mysql -h servername -u USERNAME -pASSWORD database < file.sql