A A

Tag Archive | "backups"

Quick BASH Script to Dump & Compress a MySQL Database

Saturday, December 27, 2008

1 Comment

A quick script I whipped up to dump my MySQL database. Usage: sh backthatsqlup.sh (be warned that it dumps ALL databases. This can get huge uncompressed) #!/bin/sh # Isam (Biodegradablegeek.com) public domain 12/28/2008 # Basic BASH script to dump and compress a MySQL dump   out=sequel_`date +'%m%d%Y_%M%S'`.sql dest=/bx/   function e { echo -e "n** $1" }   e "Dumping SQL file ($out). May take awhile..." #echo "oh [...]