DataFlex.wiki backup

Backup

Here are some quick notes about the backup routines for vdfwiki.com. They consist of shell scripts running on a offsite server.

• Backups of vdfwiki.com are now available by request
• http://www.mediawiki.org/wiki/Manual:Moving_a_wiki
• take snapshots of mysql dump and mediawiki settings (using cygwin)
  • tablesfile=vdfwiki-$(date +%Y%m%d).sql
  • mysqldump -u root -p > $(tablesfile)
  • mysqldump -u wikiuser -p wikidb > $(tablesfile)
  • snapshot=vdfwiki-$(date +%Y%m%d).tbz
  • tar cjf $(snapshot)
• do a automated batch script that uploads the snapshots (cron)
  • ncftpput: http://www.ncftp.com/ncftp/doc/ncftpput.html
• Compression (bzip2): http://gnuwin32.sourceforge.net/packages/bzip2.htm
• offsite 1: Jacobs home server
• offsite 2: DAE ftp server