mysqlhotcopy is a perl script that comes with MySQL installation. This locks the table, flush the table and then performs a copy of the database. You can also use the mysqlhotcopy to automatically copy the backup directly to another server using scp . 1. mysqlhotcopy command: [local-host]# /usr/bin/mysqlhotcopy -u root -p My2Secure$Password sugarcrm /home/backup/database --allowold [...]
Ramesh Natarajan
If you have more than one domain name, consolidating to a single registrar is a preferred approach. This article will explain the high level steps to transfer a domain name from one registrar to another. In this example, I transfered a domain name from Network Solutions (current registrar) to Go Daddy (new registrar). 1. Purchase [...]
In the previous articles we discussed about Nagios 3.0 Jumpstart guide and How to monitor remote Linux host using Nagios 3.0. In this article, l’ll explain how to monitor remote windows machine and the various service running on the windows server using nagios monitoring server. Following three sections are covered in this article. I. Overview [...]
Most of the Linux distro comes with MySQL. If you want use MySQL, my recommendation is that you download the latest version of MySQL and install it yourself. Later you can upgrade it to the latest version when it becomes available. In this article, I will explain how to install the latest free community edition [...]
While performing ssh from a local-host to a remote-host that are on different versions of ssh, it is possible that you may get “Algorithm negotiation failed” message. In this post, I’ll explain how to resolve this issue from the ssh client. 1. Unable to ssh to remote-host: In this example, when trying to perform ssh [...]
I will be posting “Software for Geeks” series on an on-going basis. Every post in this series will be about a specific type of software. Let us review the following five different free web based to-do list software in this post. Geeks have several new technologies to explore and cool gadgets to play with. Managing [...]
I explained previously how to Perform SSH and SCP without entering password on openSSH. In this article, I’ll explain how to setup the key based authentication on SSH2 and perform SSH/SCP without entering password using the following 10 steps. 1. Verify that the local-host and remote-host are running SSH2. Please note that ssh and scp [...]
I’ll be posting series of “Productivity Tips for Geeks” on a on-going basis targeted toward geeks who spend lot of time in front of the computer. I hate to use the mouse and use keyboard intensively for all my work. If I perform a single action more than few times using mouse, I’ll try to [...]