Automatically backup MySQL database

I needed to backup a couple of MySQL databaes automatically. Here is what I did to accomplish this. I created a folder called mysqlbackup. I then created a script called “mysqldbbackup.sh” and put this script file in the mysqlbackup folder. It contains “rm /mysqlbackup/DBNAME_backup.sql mysqldump -u USERNAME -pPASSWORD DBNAME > /mysqlbackup/DBNAME_backup.sql” I used the “rm” command to … Read more

Restore Win 08 SystemState that was recovered by DPM 07

So you have your 2008 servers systemstate backed up by DPM 2007. Your server crashes and you need to recover. DPM 2007 does not give an option to recover to the server only to tape or a network share.

 

What do you from here? The answer is you have to actually restore the system state using Microsoft’s built in windows backup utility. There is another catch it has to be done via command line using WBADMIN. Here are the steps to recover a server using Windows 2008 Backup from the command line:

Read more

Can’t connect to MICROSOFT##SSEE DB

I had a Windows Small Business Server 2008 with WSS 3.0 running on it.  I needed to get to the content databases. I tried to connect to the SQL instance using the default server name (SERVER)\MICROSOFT##SSEE in SQL Management Studio. I was unable to connect no matter what account I used. I discovered it is installed on a … Read more

Install certificate in Exchange 2007

 I recently had to renew my Exchange certificate as it expired. The original admin that set up this Exchange bought the previous certificate from Digi. I decided to go with Startcom (Free SSL) as I have used them once before in an OCS deployment and they worked out well. Exchange is a little different in that you must use Exchange management shell (PowerShell) during the process of installing a certificate for Outlook Web Access (OWA). I am going to cover 5 steps to installing a certificate Exchange for OWA.

 To Open Exchange Management Shell: Go to START >>Programs>>Microsoft Exchange Server 2007 >> Exchange Management Shell

 

This is the management shell

 

Read more

GPO disabling a Windows service

Recently I had a virtual machine that would not obtain an IP from DHCP. I noticed the DHCP client service was disabled in windows services. I would enable it, start it and it would start just fine. I would then reboot the VM. The DHCP client service would be disabled again. I had a feeling … Read more

Show hidden devices in Windows

Have you ever had devices that where stuck on your system and you needed to remove them. For example someone removed a physical network card from the system without uninstalling it first from the OS. This can be a problem if that network card had a static IP assigned to it. Once you add a new network card using the same static IP that was assigned to the previous network card it will give you an error.

If this were to happen normally you would go to device manager and simply uninstall the device. Well what if they don’t display? That means they are hidden. It is a good thing there is a way to un-hide them so you can uninstall them.

I have created a batch file that contains this:

Read more

Analyze a Trend Micro HijackThis log

 

Trend Micro HijackThis is a free utility that generates an in depth report of registry and file settings from your computer. This tool can help you detect spyware and viruses. Do not use this tool alone. Use this tool along with other spyware and virus removal tools.

Download it here:Trend Micro Hijackthis tool 

So now you have generated a log file using Trend Micro HijackThis. Here is a website that you can upload the log file on to Analyze it.

Read more