Automatically Backup MySQL Databases!

This is for you MySQL users out there. This nifty script really helps with backing up your MySQL databases. It even has rotation and it can email you the backed up databases or just a log of what happened.

I currently use it on 4 of my servers and now that I’ve setup shared keys there’s a section in the script that allows you to run any command after the backup completes. My command tells the server to synchronize the fresh backups to another server for safe keeping, VERY COOL!!

To set it to run automatically you should be familiar with cronjobs. I just set the script to run every morning at 2am.

You can read more and download the script here.

Similar Posts

  • MacBook Issues & Solutions

    MacBook Issues & Solutions By Matt@Smalldog.com MacBooks seem to have two common defects: the widely publicized “Random Shutdown Syndrome”, and a failure to…

  • Bandwidth on .Mac?

    I’ve been using my .Mac account more then ever the past few weeks, especially since Apple updated iWeb to version 1.1, and improved…

  • Now, That's Smooth: Monitoring Your Memory

    By David@smalldog.com Mac OS X uses what’s termed a “virtual memory system” (VM system) which essentially refers to the amount of memory an…