Copying large number of files between two Unix/Linux/OSX Servers

CLI, Linux, OSX, osx Server, Redhat, rsync, ssh, SuSE, Sysadmin, Tip, Ubuntu, Unix
Here are some quick tip(s) for copying a ton of files between unixy machines really fast. You're probably thinking "why not use rsync?"…..well rsync can be miserably slow if your source or destination cpu is underpowered. You can always do a rsync after these commands to make 100% certain that everything checks out, but try using one of these methods for the initial copy: One way of doing it is tar -c /path/to/dir | ssh user@remote_server 'tar -xpvf - -C /absolute/path/to/remotedir' You'll be prompted for the remote servers password or you can use the private key of the remote server using the -i switch in the ssh command. This has the side benefit of preserving permissions. An alternate version of this command can also be used to locally move folder…
Read More

SSH to your remote machine using Back to My Mac iCloud Service

Apple, CLI, Macintosh, OSX, osx Server, ssh, XServe
This is kinda cool. It only works if you have access to "Back to My Mac" service and you have it turned on in the remote mac's preferences (under iCloud preferences). If you ever need to find out the FQDN (Fully Qualified Domain Name) of your remote mac and connect to it via ssh or something like it you can use the following command in the terminal: echo show Setup:/Network/BackToMyMac | scutil | sed -n 's/.* : *\(.*\).$/\1/p' This should spit out the "domain name" for your "personal" iCloud DNS. The output looks something like this: 12345678.members.btmm.icloud.com To use this in a ssh command you would need the name of the remote machine plus the information above: ssh -2 -6 remote-hostname.12345678.members.btmm.icloud.com That's it…..you should see a prompt for ssh login…
Read More

The Ultimate File Transfer Utility for Windows

Microsoft, ssh, Windows
I've been posting mainly about OSX for the last little while, but no worries, I haven't given up on Windows...yet :-). Someone today was asking about a good WebDAV client and after searching around for a bit, it seems like there is really only a couple out there. But really none of them can beat BitKinex client in terms of features and "price". Here is a short list of features (oh...and the price thing....it's free:-) ): Site Navigation Without Freezing Windows Unique technology of advanced directory caching and multi connection/threaded directory scanning makes the non-blocking browse windows possible. Robust User Request Handling Resume and control in detail not only file transfers but all user requests - including file removals, moves, directory creations, remote edits, prints, etc. Indirect Transfers Allows users…
Read More

SSH Tunneling to mysql server using Putty

mysql, ssh, Tricks, Tutorial
 I've had this question a couple of times in the past few months (since I posted the command line version of this method here ). To make it short and sweet, yes you can use Putty in a windows environment to setup ssh tunnels. Here is the specific scenario with pics for setting up a tunnel to your mysql server (assuming mysql server is running on a machine that you have ssh access to) using putty. This allows you to run mysql-gui-tools under windows and connect thru ssh to your server, without having to open the server to accept connections from the network.Download Putty full install package Run putty and your'll see the following screen. Fill in the hostname of the DB server and choose SSH as protocol.Go down to SSH and Tunnels options.…
Read More

Tunnel to locally running mysql server using ssh

Linux, mysql, ssh, Unix
Running and administrating mysql can sometimes be a hassle especially if you're running a semi-secure environment. This usually means that your mysql server will not accept connections from outside and only localhost connections are allowed. There is a quick way of getting around this if you're stuck somewhere and really need to use that graphical admin/browser tool to get to your DB server. All you really need to do is forward port 3306 on your local machine to port 3306 on the DB server through a ssh tunnel. Here is the ssh command you need to issue to start things up:ssh -L 3306:127.0.0.1:3306 yoursshloginid@yourserver.yourdomain.comOnce you supply the password for the ssh session you're in business, the encrypted tunnel is up and running. All you need now is to point Mysql…
Read More