Backup and Email a MySQL Database

Posted on December 3, 2007 by Ben Cecka

I know there are a hundred and fifty scripts that do this, but I set out to do this within a single Crontab entry. I thought it would be nice to post and save others from having to suffer with combining a bunch of ridiculous scripts for such a simple task.

mysqldump -uusername -ppassword –all-databases | gzip > /pathto/db.gz && mutt -s Backup -a /pathto/db.gz email@domain.com < /dev/null

Voila. All data to be changed has been italicized to protect the innocent (and help you).

Technorati Tags: mysql, crontab, backup

Comments

• Categories

  • Industry News
  • Marketing
  • Open Source
  • Security
  • Site Status
  • Tech Tips
  • Technology Review
  • Web Development

• Recent

  • PCI Scan Passed!
  • Still Here
  • What is Twitter?
  • Google hijacking 404 error pages
  • A Sad Farewell to Linux
  • Synchronous versus Asynchronous
  • The Next Social Network
  • The Webtop is Dead?
  • 10,000 Records
  • Norton Antivirus for Mac

• Archives

  • July 2008
  • May 2008
  • March 2008
  • February 2008
  • January 2008
  • December 2007
  • November 2007
  • October 2007
  • September 2007
  • August 2007
  • July 2007
  • June 2007
  • May 2007

• Links

  • DistroWatch.com
  • LinuxQuestions.org
  • Lockergnome
  • SourceForge.net

• Blogroll

  • Conversation Marketing
  • Michi Knows
  • Seth’s Blog
  • Web Strategist

•   Feed
• Prefer email updates?
  

• About Me

  

  I'm the Director of Information Technology for Crown Mailing Center, a retail shipping solution provider and franchise company. I've been involved in software design, web applications, managing help desk operations, and corporate technology deployment strategies.

• Twitter

• Write Me

• ben@cecka.org

• Find Me

• Facebook
• Orkut
• LinkedIn
• Last.fm
• Digg
• Twitter
• Pownce
• Kongregate

• Search