Don’t you hate it when you know you solved a problem three years ago but you can’t remember what the solution was? I ran into that recently. I was trying to make mysql generate a csv directly from query results. I remembered that you can do it, and I had an example of the correct syntax to use in my old code, and I had a query that did it just fine when running in the mysql CLI as root. I had to piece together the answer from several different sources; and none of them told the whole story. So here is the full story, along with all the stumbling blocks that I know of.
Continue reading How to make MySQL spit out CSV’s
|
|||||
 22 comments - (Comments are closed)  Geek Stuff, SQL  CSV, DoS, escapes, FILE privilege, filesystem, INTO OUTFILE, MySQL, mysql system user, mysql user, OUTFILE, permissions, security, vulnerability
The whole ecommerce sector relies on the secure sockets layer (SSL) for encryption of transmissions and security certificates for trust. See the earlier Hot Dorkage post Credit Card Security Online for a simple explanation of how encryption and trust are meant to work hand in hand to keep you safe. Recently, however, with the aid of some power hacking, an exploit has been discovered in SSL. Continue reading SSL Vulnerability alert! 12 comments - (Comments are closed) Hacking and Security browser, CA, certificate, computing power, digital signature, Encryption, exploit, hacking, hash, MD5, SSL, trust, vulnerability |
|||||
|
Copyright © 2012 Hot Dorkage - All Rights Reserved |
|||||
Why should you care about a vulnerability in SSL? What is SSL anyway? Well…..if you never bank online or buy anything online, you’ve no cause for concern. But if you do, please at least read the takeaway action item, OK?