$cat bin/blog.tedroche.com.backup.sh
#! /bin/sh
# Dump the Database, overwriting the previous SQL if exists
mysqldump -u wordpress-user -pXXXXxxXXXXxxxXXXxxx ↵
--skip-lock-tables wordpress ↵
> ~/blog.tedroche.com.sql
# Compress the SQL, forcing an overwrite
gzip --force /home/troche/blog.tedroche.com.sql
# Send the file
scp ~/blog.tedroche.com.sql.gz ftp.tedroche.com:
cd /var/www/html
tar cvzf ~/blog.tedroche.com.20110408.tgz blog.tedroche.com/
See the man page for more options like --exclude
and --exclude-file
This document was edited with ViM, http://www.vim.org/ on Linux (also available on OSX, Windows and other fine platforms. Interoperability is Good.
The templates for the document and instructions on their use are the Simple Standards-based Slide Show System, S5 developed by Eric Meyer and available at http://www.meyerweb.com/eric/tools/s5/ under a Creative Commons license. Thanks, Eric!
Ted Roche learned to program BASIC on a PDP-4 at the age of 15. He was conferencing and IM'ing on the Dartmouth Time Sharing System in the late 1970s. (IM and chat rooms are old. So's Ted.) He shipped his first commercial app in 1978, which ran on a WANG 2200. His first public domain software was a quad-density Epson printer driver for the Commodore 64 GEOS operating system, hand-coded in 6502 assembler. Amigas were his favorite computers, although PCs are getting better. He ran the electrical plant on a nuclear-powered ballistic missile submarine until the Russians gave up, and then there wasn't any challenge in it any more. He has coded with "ohs." (requisite obscure Dilbert reference)
Since 1987, Ted has worked fulltime as a software developer. He has worked for state agencies, insurance companies and consulting firms. He established Ted Roche & Associates on July 4, 2001. Ted Roche & Associates, LLC develops Web, client-server and LAN-based applications using Ruby on Rails, Python, PHP, Apache, Linux, MySQL, PostgreSQL, Microsoft Visual FoxPro, and other best-of-breed tools. Based in New Hampshire, his company offers consulting, training and mentoring, on-site and long-distance, as well as software development services. Ted is author of Essential SourceSafe, co-author of the award-winning Hacker's Guide to Visual FoxPro series, and a contributor to six other FoxPro books and author of numerous magazine articles. He's a popular speaker at conferences worldwide. Ted is a Microsoft Certified Solution Developer, Microsoft Certified System Engineer, and nine-time winner of the Microsoft Support Most Valuable Professional award. He's earned MySQL certification twice: the Core certification for MySQL 4.x and the Certified Developer certification for 5.x. He was recently recognized by the ACM and inducted as Senior Member.
Ted has worked with Linux since 1999. The Ted Roche & Associates, LLC intranet and extranet run on Apache, Ruby on Rails, PHP, Python, WebMin, MySQL, PostgreSQL and other LAMP applications. Ted's office automation tools include OpenOffice.org, FireFox, Thunderbird, Camino, SciTE, git, Subversion, CygWin, PuTTY, WinSCP and OS X Tiger. In 2005 and 2006, he was one of the team teachers for the LAMP certificate at the New Hampshire Technical Institute's Center for Training and Business Development (http://www.nhti.edu/ctbd) along with Bruce Dawson, Bill Sconce and David Berube. He is the former Fearless Leader and chair of the board (2006-9) of the Greater New Hampshire Linux User Group (http://www.gnhlug.org) and continues to be a LAMP activist with the Central New Hampshire Linux User Group (http://www.centralug.org).
The most current contact information for Ted can be found at http://www.tedroche.com