On the fly compression of a tar-ball or mysqldump
Just to jot it down lest I forget: Tar’ing the local directory and streaming the tarball straight to gzip: tar cvf - . | gzip > target.tar.gz MySQLdump’ing directly to gzip: ...
Category Archives: mysql
Secure SSH Tunneling – at no extra cost
Assuming you have a Windows machine and you interact with Linux boxen at any stage, chances are high that you have used and interacted with PuTTY at one stage or another. That beautiful, less than 2 s ...
[SOLVED] mysql-server5.1.5.141-3ubuntu12.1 hangs on upgrade
There are a lot of words about the MySQL upgrade on Ubuntu 10.04 (64 bit specifically, perhaps the 32bit version too?) — it just hangs: You get the hopeful message: Preparing to replace mysql-se ...
Security Summit 2010 Wrap-Up
So the Security Summit 2010 has come to an end. Featuring speakers such as Moxie Marlinspike, Joe Grand and Jeremiah Grossman (again), it’s a pity to say that there wasn’t much new that wa ...
MySQL Database optimization
Just to have them all in one place, and for posterity’s sake, I’ve pulled together some points on how to optimise your MySQL programming. First off, the result of Session 1 of MySQL Camp 1 ...