Entries tagged commandline

Screenshots don’t show up on the desktop anymore on MacOS

Posted on 19. Januar 2017 Comments

This is a bug in finder, the files are being stored and will show up in the console with the ls command. However, to see them in finder, click on the Apple symbol on the top left corner, select Force Quit and then Finder. It probably would also help to just reboot.

 

Flattr this!

MySQL Workbench Error: line contains NULL byte

Posted on 21. April 2016 Comments

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

Flattr this!