SQL 복원시 오류가 발생할 때

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: ''.

 

 

덤프를 할 때 charset utf8을 추가해주면 됩니다. 경우에 따라서 utf8mb4 등을 넣어주세요.

mysqldump -u USER -p DATABASE_NAME TABLE_NAME --default-character-set utf8 > BACKUP_FILE_NAME.sql
Enter password: 비밀번호