I always have to look this up when I need it, so storing on my blog, so I can look it up faster. This is way faster than “scp”, for deep directories or directories with lots of files.
tar cf - whatever | ssh remotehost " ( cd /some/path ; tar xf - ) " ssh remotehost "( cd /somewhere ; tar cf - something ) " | tar xf -
This is incredible, by the way. Any time MySQL needs to use a tmp table on disk, you can make it use RAM disk instead.
WARNING: if the tmpfs partition you make isn’t big enough, MySQL will not be able to complete queries. Make sure you have enough RAM to do this.
mkdir /tmp/mysqltmp chown mysql:mysql /tmp/mysqltmp id mysql # example: uid=502(mysql) gid=503(mysql) groups=503(mysql) #to set up on server restart, put in fstab something like (replace gid, uid with number from above) tmpfs /tmp/mysqltmp tmpfs rw,gid=503,uid=502,size=2G,nr_inodes=10k,mode=0700 0 0 mount /tmp/mysqltmp # you don't need this: # mount -o size=2g,gid=520,uid=518,nr_inodes=10k,mode=0700 -t tmpfs tmpfs /tmp/mysqltmp #edit my.cnf, adding tmpdir=/tmp/mysqltmp/ restart mysql
The example: http://www.koopman.me/dbtable/
I got the concept of the class, DbTable, from a book called PHP5 Professional. The idea is we have a class, this abstract class, that allows us to quickly make a new class out of any database table. Database tables make good objects. We often make them names of objects, like Shopper or Product. It makes sense to create classes that represent these objects, and to have a clean, consistent way to manipulate the data in the table. It also abstracts the database layer from application logic. If you just looked at example.phps, you’d have no idea if the database was flat file, MySQL, postgreSQL, or if it was even a database at all. Abstraction is a good thing, and one of the principles of object oriented programming.