When importing CSV (or other) files into the database, scripts (especially PHP or C-related languages), will stop if there is – for whatever reason – a NULL byte in your file because it signals end of file/string, see Null bytes related issues.
So when importing a file like that with MySQL Workbench you will get this error:
line contains NULL byte
You can solve this by using the commandline tool tr (from coreutils):
tr < file-with-nulls -d '\000' > file-without-nulls
To check if there are any null bytes in your file, use the python IDE and type in:
open('filename.ext').read().index('\0')
Thanks to Pointy from Stackoverflow
