[click to continue…]
Q. I’m moving my server from local data center to another data center. I’ve new server up and running. My site is dynmic and I’d like to transfer MySQL database from old server to new server. How do I make transfer smooth and successful?
A. The best and secure way is to use ssh to transfer database to another server. You need to use following tools:
=> SSH client
=> SSH Server on remote box
=> mysqldump command
=> UNIX pipes
Let us say you would like to Transfer MySQL database called foo to remote box called bar, enter the following command at shell prompt:
$ mysqldump foo | ssh email@example.com mysql foo
You can just copy table called chocolate (from recipe database) to remote database called icecream using same syntax:
$ mysqldump recipe chocolate | ssh firstname.lastname@example.org mysql icecream
Q. I have just installed Ubuntu 6.06 and I would like to allow remote login to my system from home via ssh. How do I install and configure SSH server?
A. OpenSSH is a FREE version of the SSH connectivity tools that technical users of the Internet rely on. Users of telnet, rlogin, and ftp may not realize that their password is transmitted across the Internet unencrypted, but it is. OpenSSH encrypts all traffic (including passwords) to effectively eliminate eavesdropping, connection hijacking, and other attacks. Additionally, OpenSSH provides secure tunneling capabilities and several authentication methods, and supports all SSH protocol versions.
Ubuntu SSHD Installation
Type the following two command to install both ssh client and server:
# sudo apt-get install openssh-server openssh-client
To be frank your server is ready by default. Just test it from your home computer or from same system with the command:
# ssh localhost
# ssh user@your-server-ip-address
How do I use ssh client?
Assuming that your server hostname is userver.mydomain.com and username is vivek, you need to type the following command:
# ssh email@example.com
To stop ssh server, enter:
# sudo /etc/init.d/ssh stop
To start sshs server, enter:
# sudo /etc/init.d/ssh start
To restart ssh server, enter:
# sudo /etc/init.d/ssh restart
- Setup SSH to run on a non-standard port
- SSH Public key based authentication – How-to?
- How to force sshd server to display login banner before login (change the ssh server [sshd] login banner)?
- Read the man page of sshd, sshd_config for more information