IT Support Diary Everyday IT support issues and solutions

MySQL backup

01.06.2009 · Posted in Backup and DR

This is how I backup MySQL database on a Linux box. MySQL database location The database files are located in /var/lib/mysql directory Scheduling the backup For scheduling the backup, I used a script. The scirpt is stored in /etc/cron.daily. Note: placing a script inside the /etc/cron.daily directory means it will be executed daily by Cron. The latter ...

Cron scheduling service

01.05.2009 · Posted in Tools

Cron is a Unix based scheduler service. It is an alternative solution to the Windows Scheduled Tasks. You can download a free copy of cron here. To install cron follow these steps: Run the application to this folder C:\Windows Create a file called “crontab” using notepad, and save it without the txt extention. The filename has ...

It’s 2009, and it’s time to setup your own blog

01.01.2009 · Posted in Tools

Honestly, it is not hard to setup a blog website. You do not need to have web design skills however some webmaster knowledge is necessary. Anyway if you are thinking of starting up your own blog, follow my steps below. Get a domain name – Your website or blog will need to have a name, for example ...

WSendmail – useful little mail utility

12.17.2008 · Posted in Tools

WSendmail is a very useful tool that allows you to send emails. I use this a lot in my scripts or batch files. For example, you can use WSendmail in a batch file to send you an email whenever your hard drives are running out of space. Here is an example of using WSendmail: C:\Program Files\Mailutil\wsendmail ...

Outlook Sperry add-ins

12.17.2008 · Posted in Tools

You can make your Outlook client more useful by installing add-ins. Sperry Software has up to 37 Outlook add-ins that can enhance and expand the capabilities of your Outlook client no matter what the version. One of my favorites is the “Attachment Save” add-in. The “Attachment Save” add-in allows you to extract attachments from your ...

How safe are your websites?

12.16.2008 · Posted in Security and Compliance

How safe are your websites and your network in general? Especially if your websites handle credit card payments. Companies need to be compliant in regards to this issue as people financial information is at stake. Last month my company had a request from the Bank to do a vulnerability scan of our network, more specifically our ...

Standard Ubuntu Server Install

12.15.2008 · Posted in Linux

There are two versions of Ubuntu – one desktop and one server edition. The desktop edition comes with a GUI. Ubuntu OS is a good alternative if you hate or cannot afford MS Windows. The desktop version is very user friendly, however if you are new to Linux you might find it hard to use. ...

Net Time

12.11.2008 · Posted in Tools

It is important to keep the time on your servers in sync. Net Time is a free time synchronization tool that can be used on Windows machines. It is very easy to install and use. Make sure you have a proper time server and the port 123(SNTP) is allowed in the firewall. Add to Bookmark: ...

Workstation migration to a new domain

12.10.2008 · Posted in Windows 2003

Two months ago my company migrated their domain from NT4 to Wndows 2003 AD, and I had to prepare a tasks list for the workstations migration. When you join or change a workstation to a new domain, a completely new profile is created, for example you will lose all your email configurations and browser settings. ...