Skip to content

Instantly share code, notes, and snippets.

View dennmart's full-sized avatar

Dennis Martinez dennmart

View GitHub Profile
#!/bin/bash
echo "Deleting dennmart.com archive for $(date +%A) if it exists..."
tarsnap --cachedir /usr/local/tarsnap-cache --keyfile /root/tarsnap.key -d -f dennmart.com-daily-$(date +%A)
echo "Creating dennmart.com archive for $(date +%A)..."
tarsnap --cachedir /usr/local/tarsnap-cache --keyfile /root/tarsnap.key -c -f dennmart.com-daily-$(date +%A) /var/www/dennmart.com
echo "Making temporary database dump..."
mysqldump -u root -pxxxxxx --all-databases --add-drop-table > /tmp/mysqldump.sql
echo "Deleting database dump archive for $(date +%A) if it exists..."
# Example MySQL config file for medium systems.
#
# This is for a system with little memory (32M - 64M) where MySQL plays
# an important part, or systems up to 128M where MySQL is used together with
# other programs (such as a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /usr/local/mysql/data) or
GeoIP C API /Gem Install on Intel Mac
# Download the GeoIP C API.
wget http://geolite.maxmind.com/download/geoip/api/c/GeoIP-1.4.6.tar.gz
# Uncompress and install GeoIP C API from source.
tar zxvf GeoIP-1.4.6.tar.gz
cd GeoIP-1.4.6
env ARCHFLAGS="-arch i386" ./configure --prefix=/srv/GeoIP
env ARCHFLAGS="-arch i386" make
server@www:~> sudo mysql_secure_installation
root's password: <Enter server's root password>
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!