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: ...
Tag Archives: mysql
[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 ...
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 ...