MySQL Backup Shell Script

***TO CREATE BACKUP SCRIPT ON LOCAL SERVERmkdir /root/binvi /root/bin/mysqlbak.sh (then copy script into this file)change parameters in script to match databasechmod 755 /root/bin/mysqlback.sh ***TO VERIFY SCRIPT WORKS1. run this command/root/bin/mysqlbak.sh2. when script is done, check subdirs of /var/backup/db/daily for tarred & gzipped backups ***TO SCHEDULE THIS TO RUN DAILY, CREATE SYMBOLIC LINKln -s /root/bin/mysqlbak.sh /etc/cron.daily/mysqlbak.sh […]

Host-based routes Windows Server 2000 2003 XP

To display the entire contents of the IP routing table, type: route print To display the routes in the IP routing table that begin with 10., type: route print 10.* To add a default route with the default gateway address of 192.168.12.1, type: route add 0.0.0.0 mask 0.0.0.0 192.168.12.1 To add a route to the […]

TCP Optimization for Windows

I have recently been creating nasty batch files to alter default and non-existing networking settings to improve performance on file transfers for replication and came across this awesome tool that is free and does a great job. We set our MTU to 1350 to take in to account firewall overhead in the vpn mesh. TCP […]

Cygwin SSHd on a Windows 2003 AMI Within Amazon EC2

Recently, I needed to configure a Windows 2003 AMI in EC2 to run a ssh server. I would have expected this to be a simple job, with a variety of choices for making this work, but in the end it was far more time consuming, complicated, and frustrating than I would have guessed. Here is […]