How to Export MySQL Output to CSV
I ran into a situation where I had SSH access to a MySQL server but needed to export a table to a spreadsheet. How many ways could there be?
more ...I ran into a situation where I had SSH access to a MySQL server but needed to export a table to a spreadsheet. How many ways could there be?
more ...I ran into a situation where I was asked if there was a way to redirect a referrer in Apache to a different relative location. At first, I thought it’d be easy because you’d only need to use regex to match “referrer,” specify the relative location, and you’re done. Right? … Right‽
more ...When asking questions, it helps to meet midway by first taking steps to diagnose the issue to help narrow down the cause. Asking “thoughtful” questions that follow a structured format instead of “low-effort” one-liners helps organize a dense amount of information in an easy-to-read format. Combining prediagnosis and structured reporting solves technical problems efficiently and, therefore, faster.
more ...Do you need to create a specifically-size file down to the last byte and don’t care about the contents? It’s usually straightforward, but Windows has some extra fine print.
more ...Need to create a file with specific size and random content? One or the other is fine, but both can be problematic. I’m lookin’ at you, Windows.
more ...Our S3 cloud folder is more like a web host, but it’s not easy to share. A custom domain would make finding and sharing it easier.
more ...What is Amazon S3? Can it be a web host? Well, kind of.
more ...Need a way to send an SMS message anywhere in the world without the receiver knowing your phone number? We got you.
more ...There are many places to put random, small projects and things I’ve learned. Facebook, LinkedIn, and Medium are typical choices, but not all content types fit each platform equally.
more ...