Suppose you have a database server (db.example.com) which only accepts connections from the web server (www.example.com). The web server accepts SSH connections from anywhere (so ssh email@example.com works). And you have 200 tables to update. Start by opening a tunnelled SSH connection in a terminal window like so: [shell]ssh firstname.lastname@example.org -L 31123:db.example.com:3306 [/shell] The command starts like a normal ssh connection.
Suppose your git development process uses lots of branching. Yay branching. You want to keep them all up-to-date with the master branch, but constantly merging master into a dozen or more branches is a bit of a pain. Here's one way:
Problem: You want to host all of your web development sites in ~/Sites, and you don't want to fuck around with DNS and Apache configuration every time you start something new. Solution: DNS wildcards and Apache Virtual Hosting! The easier bit: get dnsmasq going Follow the directions here.
Grab a sudo shell and stay there: [shell]$ sudo -s [/shell]. So much nicer than [shell]$ sudo su[/shell] - it keeps all of your environment variables!