Tag: "bash"

Getting a complex MySQL resultset in CSV format on a remote client (*NIX)

Sometimes you just need a resultset in CSV (so non-geeks can read it in XLS format). MySQL has several options for that. First and foremost: SELECT (…) INTO OUTFILE. This is probably the most common one, and the easiest to use. However, this does not work if you’re on a remote client, so solution does work if you’re connected remotely?

Unlocking your SSH session after pressing ctrl+S

It happens to me on a quite frequent basis. I work in a Windows based editor for some time, and press ctrl+s every now and then to save my changes to disk. It turned kinda into a habbit. No big deal, unless… you start working in VI. Everytime, well, until now, when you press ctrl+s, it would hang up your session. Nothing you could do about it. It’s the most frustrating thing ever!