The screen utility is not included on some server builds. You *have* to have screen or tmux as a DBA or long-running scripts and DML will timeout and the ssh daemon will boot you off the server. As a workaround, I copy the “screen” binary from /usr/bin/screen on a server that does have it installed ..
Stupid command line tricks: I often run SQL jobs that can take many days to fully execute, and I always pipe the error and stdout to a file. As such, you end up with lots of lines like this in the output:Query OK, 81218 rows affected (52.76 sec)Here’s a silly one-liner that will quickly total ..
Make sure you’re using GNU find and GNU sed. find . -type f -exec sed -i ‘s/OLDSTRING/NEWSTRI..