It isn't pretty but I wrote this little script which saves 10 full mySQL backups (compressed) to a specified directory.

export DIR="BACKUP DIRECTORY HERE"
export UNAME="MYSQL USERNAME HERE"
export PASS="MYSQL PASSWORD HERE"
### End Config ###
printf "Starting at "
date "+%m-%d-%Y %H:%M:%S"
printf "Rotating Backup files..."

These methods will most likely seem basic to a seasoned web host but until I was forced to switch web hosts I never had to seamlessly move sites between servers.

Almost all clients used numerous mySQL databases that had content being accessed 24/7 (forums and purchase requests to name two). Any entries that were added on the old server had to be placed on the new server in real time.

To start this blogging shindig I thought I’d share my story of why I even have this domain. It all starts with my old web host which was owned by a single guy (and no I don’t mean he wasn’t married) running a server leased from ThePlanet. About three months ago I started noticing my [...]