Windows 2003 - PowerCram Blog - Page 2

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 ***TO RESTOREmysql -uUSER […]

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 Optimizer is the […]