Jump to content

Edit History

Vignesh R

Vignesh R


moderator name mentioned previously

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.

Vignesh R

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 razaro.

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.

×
×
  • Create New...