June 2008 Entries
I just setup the following super simple backup script on our Six Day Development server. I know it needs more features. Perhaps the ability to rotate through the backup files. But shouldn't that be the job of my offsite backup job and not my local dump routine? Anyway, here its. @echo off
:: Usage: CommandFilename [BackupType]
date /T
time /T
echo.
::
:: Set mysqldump parameters
::
Set mysqluser=root
Set mysqlpassword=xxxxxxxx
Set mysqlHost=localhost
Set mysqlOptions=--opt
::
:: Set backup file location
::
Set backupDir=D:\Data\Backups\MySql\
Set baseFileName=%backupDir%mysqlbackup_%date:~10,4%%date:~4,2%%date:~7,2%
set backupFileName=%baseFileName%.sql
Set zipFileName=%baseFileName%.zip
:: -----------------------------------------------------------------------------
set mysqlcmd=mysqldump %mysqlOptions% --all-databases --user=%mysqluser%
--host=%mysqlHost% --result-file=%backupFileName%
echo.
echo Performing mysqldump of %mysqlhost%
echo Dump command: %mysqlcmd%
echo.
:: Execute the...
We ran into an interesting error today trying to send email from our company web site using our Google Applications for Domains smtp server. In short here was the code we were using to send email from our contact form:
public static void SendMail(string to, string subject, string body)
{
var m = new MailMessage()
{
Subject...
Today I had my first "Aha!" moment with IIS7... well almost. I've been using IIS7 locally on my Vista development machine for some time now but I must say I've been missing the familiarity I've gained with IIS6 over the last several years. Now before somebody starts telling me about all the great new features in IIS7, I love the way IIS7 allows more configuration in side my web.config files for ASP.Net and I'm ecstatic about how it supports the new ASP.Net MVC framework. It's just that I haven't had much time to really play with these new features....