Posts

Auto Backup using Dropbox in Linux/Mac

I had some folders on my disk which I wanted to keep a copy online as a backup and for viewing from other places. Its not always possible to save all the essentials in the drop box folder itself to be auto backed up. Thus I wrote a very small script which  …

Important MySQL DBA Interview Questions

Here are a few sets of interview questions expected for MySQL DBA position.These are compilation of the usual questions from various DBA texts: What is Log Switch? – The point at which ORACLE ends writing to one online redo log file and begins writin …

Script for Auto Copying of Cds/Dvds

Here is a script that i created for automatically copying all the files in cd to a folder and ejecting and waiting for the next cd. So here is how it works. You need to change the folder names and paths accordingly. And the shell script as [shell]  …

Adding RedHat DVD as Repository

When we try out a new linux OS its always a pain to download and install all the software and  add packages we needs on that. Its even worse if you don’t have an unlimited connection. But actually most of the software we need is already there in the CD/DV …

Customizing Mysql Prompt For multiple Servers

If you are using mysql regularly on multiple servers its really useful to have the promt in mysql to show something more than mysql>. It would be useful if it showed the username,hostname, current database and things like that. So how to do this.  …

Restoring the Grub after reinstalling Windows

After reinstalling windows or fixing MBR(Master Boot Record) you always loose your grub and you cannot boot to your linux. So this post is about the methods of restoring the grub. There are three methods I use. I will explain all three. All three meth …

How to Format a Usb in Linux

There are two methods of formatting a usb in linux that I use. The first method is using gparted (or parted non gui version of gparted). This is an easy gui interface that uses shell commands as backend. It is easy to do it. You install this package u …