Skip to content

Instantly share code, notes, and snippets.

View evansims's full-sized avatar

Evan Sims evansims

View GitHub Profile
@evansims
evansims / Prerequisites
Created November 13, 2012 01:26
SQL Backups0rz
apt-get install pigz
@evansims
evansims / backup_mysqld.sh
Created March 5, 2012 15:17
Backup Databases to Individual ZIPs
#!/bin/bash
mysqlUser=""
mysqlPass=""
backup="/home/username/mysqldump"
databases=( $(mysql -u"$mysqlUser" -p"$mysqlPass" --skip-column-names --batch -e "show databases;" 2>"$temp") );
echo "found ${#databases[@]} databases.";
for i in ${databases[@]}; do
@evansims
evansims / backup.sh
Created June 1, 2011 20:33
Nightly Backup Script
#!/bin/bash
mysqlUser="MYSQL USER"
mysqlPass="MYSQL PASSWORD"
backup="/path/to/backups/"
folders[0]="/home/user1/"
folders[1]="/home/user2/"
folders[2]="/var/lib/mongodb/"