[racktables-users] Re: Windows 2008 IIS & MS SQL

This is the script that I run from Cron and works very well for me..

#!/bin/sh
DIR=/usr/local/mysql-backups/
DATESTAMP=$(date +%Y%m%d)
DB_USER=julio
DB_PASS='iglesias'
# remove backups older than $DAYS_KEEP
DAYS_KEEP=5
find ${DIR}* -mtime +$DAYS_KEEP -exec rm -f {} \; 2> /dev/null
# create backups securely
# umask 006
# list MySQL databases and dump each
DB_LIST=`mysql -u $DB_USER -p"$DB_PASS" -e'show databases;'`
DB_LIST=${DB_LIST##Database}
for DB in $DB_LIST;
do
  FILENAME=${DIR}${DB}-${DATESTAMP}.sql.gz
  mysqldump -u $DB_USER -p"$DB_PASS" --opt --flush-logs $DB | gzip >
$FILENAME
  echo $FILENAME
done


-----Original Message-----
From: racktables-users-bounce@xxxxxxxxxxxxx
[mailto:racktables-users-bounce@xxxxxxxxxxxxx] On Behalf Of Jason
Ledford
Sent: Tuesday, March 23, 2010 8:46 AM
To: racktables-users@xxxxxxxxxxxxx
Subject: [racktables-users] Re: Windows 2008 IIS & MS SQL

Just to add to the pile, this is the best mysql backup script I have
found
http://sourceforge.net/projects/automysqlbackup/ never tried to migrate
it to windows though :(

runs nightly and I have a week's worth of daily's, a month worth of
weekly's, and a year worth of monthly's. 

For server 08 though IIS+PHP would be the way to go http://php.iis.net/
And is very easy to install.





Other related posts: