MySQL backup script

I just basically run this script on a cron job every night.

#! /bin/bash
BACKUPDATE=$(date +%Y%m%d).sql.gz
echo "Start backup SMFSG"
mysqldump -u username -ppassword dbname | gzip -v9 > /destfolder/smfsg$BACKUPDATE

Updating server

I'm currently making backups of the database and migrating all the galleries to a new computer. Hopefully everything will turn out okay. Hmmm... let's seem I'm at 20 wpm now using dvorak keyboard layout, it seems to have a lot of promise with regards to speed, but my main concern is that I seem to be forgetting QWERTY the more I use dvorak.

After the backups I need to restore them to the new server, and then pray that SMF and all my other settings work on the new one.

Powered by ScribeFire.